Search results

Wow...many thanks for that! I'll have a go at implementing this and I'll let you know how I get on. I really appreciate you taking the time to help. Dave

Many thanks fo ryour reply. I'm not sure if the link helps much much unfortunately, it doesn't really give a clue how to solve my problem. The database does work the way I've set it up in the second image (see attached) but I can't enforce referential integrity. I can't really see a way round...

Hi everyone, I hope I'm able to explain myself with the problem I'm having. I've provided a couple of screen capture which may help. I'm using Access 2007 and I'm trying to design a database for my stock inventory which I can then use to interrogate for order, purchasing stock check purposes...