Search results for query: *

Thanks sko. Not sure why the relationship reverses your mock-up. I have tried the query approach but I run into strife. If you are interested, this is my dilema in detail... I am running a linked data set (tables) to front end UI(forms). I am currently using 2 tables (plus many others) to...

Yes you are correct, the '_1' extension you refer to is as a result of Table1 being added to the relationship window a second time. And yes there is a self join from ID to SubID with forced referential integrity and cascaded delete. What I am pinning my hopes on is the fact that Access...

I vote for joe's solution... simply and less prone to typo's.

Thanks.... I have a suspicion that what you say is correct, but I am bewilderd why everything, including cascaded deletes, works OK before the database is saved for the first time. I may not have made it clear that the table in question has a second field/column that is the subordinate to the...

Just adding the finishing touches to a 12 months project and am getting hung up with a persistent error message. I need to run with referential integrity so I can use cascaded delete on a single table, but get this persistent 'locking' problem after I save the database and reopen it. In...