Recent content by ScottV

I know. It's a bit of a pain. I probably didn't do the best job of normalising the tables. I thought of starting again but I leave my job in a couple of weeks and needed to get this in place before I went. I thought of starting again and getting a junction table in to handle the many to many...

Hi All I've attached screenshots of the table relationships and some nested forms that I need to discuss in my database. If you look at the forms screenshot you'll see I have a main form "business/cmc issues" that uses a combo box to select a business name; nested into that I have a second...

Sorry for the confusion. Business Update and Policy Issue Update is the same thing. I named the table before I thought it through fully.

Hi All I'm trying to put together a fairly simple database that in my mind has 3 tables: 1) Businesses 2) Policy Issues (with a business ID foreign key and joined to Businesses) 3) Policy Issue Updates (with a business ID foreign key and joined to Businesses; and a Policy Issue ID foreign key...