If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Select for name and address

12-14-2015, 08:28 PM

Hi, I have a simple form, Company Name, Address, City, State, Zip Code, Telephone. I have Company Name as a select field and it works just as it should. What I need it to do is show the other fields too, so if I choose Acme Credit Corp from the select field it will give me Acme Corp + Address, City, State, Zip Code, Telephone. What I also need is the option to insert a new record if the Company Name I need is not already listed.
Thanks in advance

Comment

Thanks aari77, here's the SELECT I'm now using:
SELECT SupplierID, sc_concat(PurchasedFrom,' ',street,' ',city,' ',state,' ',zip,' ',telephone)
FROM tblsuppliers
It works in as much as I get all the fields I want, but they're all in the PurchasedFrom field instead of populating their own fields. Don't think I made this clear in my original post. I've attached a screen shot...Any ideas?? ThanksSupplier.JPG