Make a lookup table show all fields where it is looked up (?)

[mrapoc]

Hey

I want my lookup table to show more than the initial entity in a field (think i got the right words there).



As you can see I need to have more than the manuf showing so i can double check orders etc.

Thanks

 

[SOS]

You should not be using lookups at the table level. See here for why and then use them at FORM level.

 

[mrapoc]

oh dear.

seems i have been taught wrongly

so

if i delete all relationships, remove all lookups in the tables (basically have no relational data) up until the forms and then start setting the lookup relation

unless i can still have a relationship but without the lookup table (using the relationship view)

can you guess i'm a beginner lol

 

[SOS]

oh dear.

seems i have been taught wrongly

so

if i delete all relationships, remove all lookups in the tables (basically have no relational data) up until the forms and then start setting the lookup relation

unless i can still have a relationship but without the lookup table (using the relationship view)

can you guess i'm a beginner lol

Well, actually you can TEMPORARILY keep the lookups at table level if you want them to help the form wizard build your form with combo boxes.

You do not need to change your relationships due to this. They would still be the same. It is just that you are saving the ID number (foreign key) from the combo selection into the table via a form instead of at the table level.