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

Access form autofill

P: 1
I have two tables:
Enquiry - Enquiry number ; Company ; Product
Order – Customer Name; Enquiry Number ; Company; Product

I wish to create a form for the ‘order table’, which automatically fills ‘company’ and ‘product’ if the ‘enquiry number’ matches the ‘enquiry number’ from ‘enquiry table’. It doesn’t have to be bound, as in I should be able to fill an order without a matching enquiry also.
Can anyone please instruct me in layman’s language what should I be doing?

Thank You.
Jan 3 '12 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,494
What you need to do is to avoid duplicating data at all in the way you propose. Instead, simply access the data via the link whenever required. See more on this concept at Database Normalisation and Table Structures.
Jan 3 '12 #2

Post your reply

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