Add new entry from subdatasheet

[Faeyren]

I am trying to make it so that I can add new (receipts) to my (repairs) table.



So for example, if I am replacing carpet and go to home depot for parts on 2/23 then again on 2/25 I can attach the (Receipts) to the (repair)

I can do it with the repairID. But what I would like to do is when I hit the subdatasheet for that particular dropdown, it automatically puts in the repairID?

[ranman256]

You should be using a form. A parent/child form.
put in combo boxes where needed.
the child form, would link to the repair id, and put it in for you.

[orange]

You should not work directly with tables. Use a form, or in your case a Form for Repair and a subform for Receipt. The linking field would be the RepairId. From a design perspective you would have a tblRepair and a tblReceipt. These would be set up in a 1 to Many relationship. (!Repair may have 1 or Many Receipts)

Good luck.

[Faeyren]

I will try these. Thanks