relationships

[baweld123]

Hi Guys i was wondering if anybody could help me as I'm going crazy. My database is as enclosed picture and has been working brilliantly until i wanted to add the 009 and 030 layouts.

each customer has different staff (BS Input) some then also do IMI but not all . I have a portal on the BS layout to populate the IMI.

There is two parts too the IMI that they can do.

1 is 009 and the other is 030

In BS testing i have a portal to 009 and another for 030 

I also have a button to a layout on each that i have to input more data for the 009 . when i press this button to go to related fields i get a different customer?

I'm sure this was working but now its not.

Thanks 

 

[eos]

It would be helpful if you'd explain the purposes of and processes in your database in layman's terms.

Besides that: you have two PKs in your IMI table, which makes no sense – a database should have exactly one primary key. If at all, you should have an IMI PK in the IMI table, and relate the 009 and 030 tables via an IMI FK, i.e.

IMI::pk = IMI030::imi_fk

And if the entire structural difference between IMI009 and IMI030 records is their type, you could use one table and an additional type field to distinguish them.