Hi Guys,
I'm currently updating (major overhaul) a database system I built a few years ago. As part of that update, my Order Details table has several new fields: one of these is linked to a new table (one to many relationship from the new table to Order Details). When I add the new table to my query (that runs my point of sale subform) the data disappears.
Is there a way out of this - can you see what is happening? I have joined the table in the relationships window, enforcing referential integrity.
Thanks,
Stonward.
I'm currently updating (major overhaul) a database system I built a few years ago. As part of that update, my Order Details table has several new fields: one of these is linked to a new table (one to many relationship from the new table to Order Details). When I add the new table to my query (that runs my point of sale subform) the data disappears.
Is there a way out of this - can you see what is happening? I have joined the table in the relationships window, enforcing referential integrity.
Thanks,
Stonward.
Comment