I have an order entry form on which I create a customer and then sell products. One of these products is Hotel Rooms.
The workflow is select customer, sell a Hotel Room (updating tblTransactions) and then click a button which opens fmAccomDetails whose purpose is to capture additional detail of that line item - say how many beds in the room, arrival date etc.
The relationship between Guest and products is many to many so there is a joining table in there.
The problem is a user could create more than one record in the tblAccomDetails and associated joining table - and I need to fix this.
I haven't figured out a unique index tying the record in tblTransaction to tblAccomDetails.
So I thought the next best thing would be for the fmAccomDetails to open in a filtered mode (continuous form) showing all entries in tblAccomDetails that match a particular line in tblTransactions. This way any duplications in tblAccomDetails for a particular line item in tblTransactions would be listed and could then be deleted, or perhaps there would be no entry, meaning that one needs to be created.
Can I write a query for fmAccomDetails that would allow this flow? Are there better ways to achieve this.
Apologies if the information is insufficient - I am trying to make it 'conceptual'.
The workflow is select customer, sell a Hotel Room (updating tblTransactions) and then click a button which opens fmAccomDetails whose purpose is to capture additional detail of that line item - say how many beds in the room, arrival date etc.
The relationship between Guest and products is many to many so there is a joining table in there.
The problem is a user could create more than one record in the tblAccomDetails and associated joining table - and I need to fix this.
I haven't figured out a unique index tying the record in tblTransaction to tblAccomDetails.
So I thought the next best thing would be for the fmAccomDetails to open in a filtered mode (continuous form) showing all entries in tblAccomDetails that match a particular line in tblTransactions. This way any duplications in tblAccomDetails for a particular line item in tblTransactions would be listed and could then be deleted, or perhaps there would be no entry, meaning that one needs to be created.
Can I write a query for fmAccomDetails that would allow this flow? Are there better ways to achieve this.
Apologies if the information is insufficient - I am trying to make it 'conceptual'.
