Multiple Entries = Multiple Tables/Subforms?
Posted: Thu May 17, 2018 12:20 pm
Hi All, I am hoping I get get some help on this one as this one problem is stopping me from progressing with my database. I have asked other questions and viewed tutorials but still have not been able to progress. Therefore I thought I would try again but with a clearer definition of my requirement.
I require a form (with or without subforms) to allow the entry of details received from a customer enquiry. The customer with send in an enquiry with a reference (CustRef). The enquiry will consist of PartNumbers. Each PartNumber will have its own PartRef.
So when adding a new CustRef I could be adding several PartNumbers on the same form. Each PartNumber would need to have its own Primary Key to be auto created at time of entry. I believe the PartRef would also need to have its own Primary Key?
I have attached a simple sheet showing roughly what I need to achieve. The PartNumber is the main factor in this database. I already have a PartNumber Table which uses PartNumberID as a Primary Key. I am unsure which new table I need to allow the above. I think I need CustRef and PartRef but not been able to make it happen in a single user friendly form.
I really appreciate any help here as struggling badly despite checking out other posts and example. I have actually had to put this to one side for a number of weeks as I was not progressing.
I require a form (with or without subforms) to allow the entry of details received from a customer enquiry. The customer with send in an enquiry with a reference (CustRef). The enquiry will consist of PartNumbers. Each PartNumber will have its own PartRef.
So when adding a new CustRef I could be adding several PartNumbers on the same form. Each PartNumber would need to have its own Primary Key to be auto created at time of entry. I believe the PartRef would also need to have its own Primary Key?
I have attached a simple sheet showing roughly what I need to achieve. The PartNumber is the main factor in this database. I already have a PartNumber Table which uses PartNumberID as a Primary Key. I am unsure which new table I need to allow the above. I think I need CustRef and PartRef but not been able to make it happen in a single user friendly form.
I really appreciate any help here as struggling badly despite checking out other posts and example. I have actually had to put this to one side for a number of weeks as I was not progressing.