Subforms

M

Mr. B

I have a table called products. In there I am entering all the info about
each product we buy, ie, SN RID MODEL ACCESS# etc. In the Customers form I
created, I have a subform that lists all the fields from the products table.
I want to be able to type in the access# and have the rest of the fields from
that record in the products table populate automatically. Can I do that? If
so, HOW?
 
R

ruralguy via AccessMonster.com

Simply join the Customer table and the Product table on the ACCESS# field in
a query for your Customer form. I hope you are not using the octothorp "#"
in a field name.

Special characters that you must avoid when you work with Access databases
http://support.microsoft.com/?id=826763
 
Top