Forum Discussion
Solved
MS Access 2016 - Working with Forms and multiple Subforms
Hi!
I finally have my relationships the way they should be. But I have no idea to create subforms of a subform... to enter the data. Here are the relationships - and thank you in advance for any help you made provide!
- I see another design problem: you have both Location.JobNum_ID as well as JobNum.Loc_ID. That could spell trouble.
I would recommend spelling out the table names, and decide on all singular or all plural names. Use as few abbrevs as possible.
Remember, you are also doing this for the person after you.
3 Replies
- I see another design problem: you have both Location.JobNum_ID as well as JobNum.Loc_ID. That could spell trouble.
I would recommend spelling out the table names, and decide on all singular or all plural names. Use as few abbrevs as possible.
Remember, you are also doing this for the person after you.
