Welcome, Guest
Username: Password: Remember me
  • 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
Time to create page: 0.071 seconds

This is what you call a component builder. I was able to master using this in a very short time and the resulting component works like a charm. Not just a basic component builder but a fully working component builder with forms fields tables all ready to go. You can make the list and item views to display in the front and back end. Also there is a great forum just starting to evolve and I'm sure this will grow very rapidly when you all realise how good this tool is.
Kevin (JED)

         

Get Started