foreign key ???

[neils]

I have a db with 4 tables

contents (employee_id, location_id, asset_id)
employees (employee_id, employee_fname, employee_lname)
location (location_id, location_name)
assets (asset_id, asset_description)

when i bring up the contents table screen all i seem to be getting is the "id" record numbers, my screen looks like this:


Employee....Location....Asset
1 7 5

What I would like it to look like

Employee.........Location............Asset
John Smith Tampa Dell Laptop


In this example:
employee_id 1 = John Smith
location_id 7 = Tampa
asset_id 5 = Dell Laptop


basically it is returning the record id instead of the record id "value"

does this make sense? any help is appreciated. Thanks


Neil

 

[PLMresearch]

Neil,

There are a bunch of hacks listed in here (search on foreign keys) that will help you accomplish this. Dadabik does NOT do what you want out-of-the-box. You will have to modify your code.