forms

[treyxman]

You have the subform in the main form right? What you should do is have the subform set to always appear in datasheet view, that way you will be able to enter multiple things per order #

[Ray67]

I have it as datasheet view for the subform but when i enter multiple things on the subform it only give's the main form one order # and the sub form multiple order #. I would need for the main form and the subform to have the same amount of order #. So what i enter on the main form it would copy it to the subform for all multiple things.

[treyxman]

is the order # an auto number? you would need to use it as a specific number like 78737 or something to that effect. it can't be an auto number. you may have to do some playing around with the relationships, because you will need the relationship to be one to many, so one order# can have multiple records associated with it

[Ray67]

After thinking about it i won't be using an order number.

is the order # an auto number? you would need to use it as a specific number like 78737 or something to that effect. it can't be an auto number. you may have to do some playing around with the relationships, because you will need the relationship to be one to many, so one order# can have multiple records associated with it

[Ray67]

Hi

I got it to work. This is what I did. The first table I left it with the auto number and the auto number is the primary key. Now the second table I took off the auto number and primary key. (Do you think not having a primary key on the second table would be a problem????) I did everything else the way you told me. When i go back to the tables to see how the info is stored, it stored all of the info in table A. If I click on the + it drops down with the info from table B. I also did a query from table a and b and it gives me all of the info.



Thank you,