Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Forum
Support forum
Coding inside your component
[Solved] : Save name not id on Foreign Field
  • Page:
  • 1

TOPIC:

[Solved] : Save name not id on Foreign Field 31 Dec 2013 05:24 #11873

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.

Please Log in or Create an account to join the conversation.

Last edit: by jonathanbell.

Save name not id on Foreign Field 01 Jan 2014 22:14 #11877

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')

Please Log in or Create an account to join the conversation.

Last edit: by jonathanbell.
  • Page:
  • 1
Forum
Support forum
Coding inside your component
[Solved] : Save name not id on Foreign Field
Time to create page: 0.068 seconds
“
”

  I found "cook" two days ago. Played around with it for a day and then within a day got rid of two legacy applications in IBM Lotus Domino Notes and replaced them with "cook". It was really easy. A piece of cake. Actually it was even easier than cooking. Cooking involves more work than developing with "cook". What can I say about "cook"? Great application great price for what it delivers great forum with a lot of information and fast responses active and friendly community fast forward moving development cycle So what should I say "Monsieur Le Cook"? Keep the good work going it will lead to success. Having become a paying member in the words of Edith Piaf may I say ..... non rien de rien ... je ne regrette rien. Vive La France.
FK (JED)
         

Get Started

Log In Sign In