Relationships with Lookup.

[chuckcou]

This should be easy, but I can't figure out why this won't work.

2 Database

[color:orange]Database1

Manufacture_ID (serial, unique)

Company

Address

Database2

Manufacture_ID

Company

[color:green]All I want to do is be able to have a drop down manu for Company and have the Manufacture_ID from database1 be added to database2

Of course database1 Manufacture_ID is uniuqe for ID perposes.

[color:green]How would I do this?

Thanks in advance.

[Søren Dyhr]

Well you don't as soon as the ID is given a value can the related value be seen, just by pulling a field from the related table into you present.

Lookups are for different purposes, namely historic data such as prices in invoices when they're likely change later!

--sd