Creating junction table - relationships

[jaryszek]

Hi !



I am trying to create junction table like here:



This is ok because i have for all these fields references to satellite tables.

Problem is where i want to add also FK to workload table. Because workload is characteristic only for specific Junction_ID (so It can be nullable).
To avoid this i created relationships like here:



and now when i am creating form there is a problem to input data. I can create something like here:




but i can not insert into this.

How can i achevie similar effect like for other tables? (FK in junction table refered to PK in satellite table).

I can write VBA code which will be use after uptade event for choosen WorkloadName and will be inserting data into t_junctiontoworkload but i am not sure it is the best option here.
Maybe i should put this Nullable FK in t_junction table? But with nullable i can have a lot of problems handling data integrity later - database is on postgresql BE.

Please help,
Jacek

[isladogs]

If fields can be null, use outer joins for one or both links

[jaryszek]

thank you workinf !!

Jacek