By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,398 Members | 1,362 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,398 IT Pros & Developers. It's quick & easy.

Question in creating Form?

P: 1
Here's my data first.
Table1 - Payee List
Field1 - Payee ID
Field2 - Payee
Field3 - TIN
Field4 - Address

Table2 - Voucher
Field1 - Voucher Number
Field2 - Payee
Field3 - Transaction Amount

Now this is the data that i wanted to see in the FORM i wanted to create from the table

Voucher Number - Auto Number
Payee - Encode
TIN - Automatic based on Payee
Address - Automatic based on Payee
Transaction Amount - Encode

I'm just a beginner in using Access thanks for advance.
May 8 '15 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 15k+
P: 31,768
If [Payee] references the name then you want [Payee ID] in the [Voucher] table instead (although I'd never recommend using spaces within names).

Now we have the background - what's the actual question?
May 8 '15 #2

Expert Mod 5K+
P: 5,397
I've PM'd you with a copy of some basic tools and tutorials that will help you get started with Access - Please check your Inbox.
May 12 '15 #3

Post your reply

Sign in to post your reply or Sign up for a free account.