Search results

Sorted cheers. Had to populate table 1 at the above point as otherwise it wouldnt let me populate table 2 due to linked records. Thinking about it deleting and recreating the relationship was a bodge anyway. Thanks for your help :)

Thanks for the reply Ben I'll give it a go. Sounds like a bit of a bodge though!

Hi, I cant change everything but the primary key in the first table as it won't always be the same set of records that is pulled back - there may be additional records. I also don't want the record deleting from the second table (i've not got cascade deletes set) as I need to keep a record of...

Hi Newbie to the forum but consider myself an 'ok' coder ;) Can't see that this question has come up anywhere but apologies if it has. Background Creating a db for work. I've got two tables linked in a relationship. 1 will get refreshed on a weekly basis and will contain differing...