Jump to content
Sign in to follow this  
Shadowizoo

Pictures do not show up

Recommended Posts

I got 5 tables (Picture, Event, Consequence, Cost and Login).

The table picture has some container images (not global).

The relation between Picture(serial key) and Login(serial key) is an "X".

The relation between Login(serial key) and Event(serial key) is an "X".

The relation between Event and Consequence is a "=". The field "_fkEvent" in the table Event is linked with the serial key of Consequence.

The relation between Consequence and Cost is a "=". The field "_fkCons" in the table Consequence is linked with the serial key of Cost.

My problem is that my images in the table Picture does not show up when I'm in my table Cost but it does in Event or Consequence. I checked if I had a problem in my link (wrong number in one of my field) but it's all good. I can correct my problem if I put a new instance of Picture linked with an "X" with Event, but I'd like to know why this is happening. Any ideas ?

Share this post


Link to post
Share on other sites

I'm hope I'm making proper since of this, but from what I can tell, picts is related to log in (1), which is then related to events (2), which is then realted to consiqunces (3), wich is then related to cost (4). But from Picts to login and login to events (1,2 and 3) you are using the field serial key, but after that other fields. So it looks like the cain is broken at that point.

Share this post


Link to post
Share on other sites

If I understand the chain correctly as:

Costs -< Consequences -< Events -x- Logins -x- Pictures

you will see all Pictures from a record in Costs only if that record has at least one related record in Events, AND there is at least one record in the Logins table.

Other than that, it seems strange that:

The field "_fkEvent" in the table Event is linked with the serial key of Consequence

The foreign key field in the Events table, linking to the primary key in Consequences, would be normally named ConsequenceID. I'm not sure if it's just a misnomer or if there is a real problem with the relationships.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.