Rooms and orders

[Seldek]

Hi, my name is Kevin, and I'm new to the forum! I have a one-to-many relationship with Job --> Rooms, then from Room --> Orders, and then Orders-->LineItems. In creating my forms I want data entry to be fast. If an order record is added in one room (a.k.a. Date of Order), then I want a new order record to appear in every other room record under that job -- with the SAME date of order. So I don't necessarily want a many-to-many relationship between rooms and orders. Are there any suggestions for automating this process?



Thanks for having me!
Kevin

[June7]

Automation means code, probably VBA, to add records. This can be complicated. Might be possible with an INSERT sql action. The real trick is figuring out what event to put the code in. Don't know your database well enough to be more specific.