Forms using mutiple tables

[cantord]

I have a table with many fields ProductID is teh PK. I have categorized the fields and created forms for each category, How do I link the forms to save the data from all the forms into the same record in the table? when I enter data into each form that data is saved as different records. I also only want to enter the id field value in the first form the second form needs to add its data to the same record not create a new record. i added a ProductID field in each form just for informational purposes.



Thanks in advance for any help you can offer!

david

[rpeare]

I'm sorry your question does not make any sense to me. can you supply a sample of your database (convert it to 2003 please) then upload it to this site.

[cantord]

i am asking how to connect data from two forms and save them as 1 record in the table.

[rpeare]

This is why your question does not make sense to me.

You only mention 1 table, but you say you have multiple forms linking to that table, one form for each category based on your description. Why? There's no reason to make a different form to split up data that's maintained in the same table.

After that your description of what's going on makes even less sense to me, I'm sorry but I can't even begin to guess at your data structure and form structure to offer you a possible path.

[cantord]

I am sorry i was unclear, I have two tables joined with a PK ProductID I created two forms to enter data into each table how do I link the data from the second form to the data in the first without having to enter the ProductID again in the second form. It would be great if after entering data into the first form I click the button to the second form, the ProductID will appear in the second form, getting the ID from the first form. I will then be able to add the data to the second table and then move to the next record.

[rpeare]

This kind of question depends totally on what you are doing with it.

For instance, if one form is your basic product information, and the second form is say a line item on a purchase order that's got nothing to do directly with the product, that's one question.

If, instead, your second form is directly related to that product, for instance receipts of product, shipments of product that's a completely different question.

if it's the former I don't think you'd want a button to do that, you'd like just have a combo box with the product name visible but the product ID as the bound column for your data entry.

If it's the latter I'd likely use a form/subform.

I can't think of a reason why I would have two separate forms based on my perception of your description.

[cantord]

the second form is additional information related to the same product.

[rpeare]

Then use the latter suggestion

Build a subform with the additional information on it and when you add the subform to the main form link it on the product ID

[cantord]

the subform will not fit on the form because the first form is very big

[rpeare]

This is why I asked for a sample database, it's extremely hard to tell you how to approach your problem without an example of your data structure/object structure. Sorry I couldn't be more help.

[cantord]

thanks for trying to help!
I cannot post a sample database.

[rpeare]

Yes you can, just make a copy of your current database, take out any sensitive information (in fact it would be better to remove everything except the objects you're having trouble with, 2 tables, 2 forms) and just put enough garbage data in there to give a sense of what you're trying to do, then zip it up and upload it. (please convert to something lower than access2010 if you're going to do it)