Data Entry Form (again)

[Saaraa]

What I want to do is create a data entry form ( lets say i want to create a form for entering a company name and it's products, so i have for the same company more than product and this mean i need to insert multiple values for the products field for the same record. how to do that?? i want a form looks like an endless datasheet. I hope that my question is clear!!! please reply!!!

 

[Jack Cowley]

Create two tables like this:

tblCompany
CompanyID (Primary Key & autonumber)
CompanyName
Address
...rest of the fields...

tblProducts
ProductID (Primary Key & autonumber)
CompanyID (Foreign Key & Long Integer)
ProductName
...rest of the fields...

Join the tables in the Relationship window on the CompanyID field. Click the Referential Integrity button. Next create a form in datasheet view based on the Products table. Save the form. Next create a form based on the Company and add a Subform using the Products subform.

Now you will be able to select a company and add all their products in the subform.

hth,
Jack