Tables - Field Linking!!!

[Paul Mickleson]

I have a small problem in that in my database, some fields
are the same. I.E.

The Chief Exec company address, is the same as the
company. What would be nice would be to forward the
address information through some kind of link, so the user
doesn't have to keep re-typing the data.

How would you go about creating this sort of link? Also
how could you create a button within the form that would
then forward the address at the user's discretion? In some
cases the address may be different!

PM

 

[Mauricio Silva]

I would give 2 options:

1- Create a table of addres, with an AutoIncrement ID. At Company and
Employee I would create a field called AddressID and change it at will.

2- You also could create a field at Employee called ForwardCompanyAddress as
boolean. If its true, ignore Employee address and use Company Address.

I hope I could help.

Mauricio Silva