Hi, I must be missing something. Can I force a Foreign Field to save Text instead of the ID of the Foreign Field.

For example: I have a table called Sites with the auto ID , Site Name & Address

I have a table linked to it that I want to save the ("Site Name") to in the database, rather than the id number.

I need this to do this so I can get a Chart Component to work with my Component I am Building.

Another option I suppose due that the Foreign Key saves the id number could be to copy the result from the field into another field.

e.g person selects site: Warehouse ( id1) and the form places the word Warehouse into another field that the data base could then use for other reasons.
Any easy script to add to the form that would do this? On any PHP forum or help site? It does not have to save the field immediately, this could happen when the form is submitted.

Cheers if anyone has the answer. ("I'm not a coder')