Let's frame this question so it could be interpreted better:
Let's say that we have a database called Wellness_Events on this database I have 3 tables and they are called:
Events
Contacts
Snacks
Currently I have the application configured so when the user enters a new Event on the Events Table the customer is going to be automatically redirected to the next table to enter the Contact information on the Contacts table and finally it will redirect the user to enter the snacks.
The problem that I have is that when I redirect the customer to each step the customer has to select their company name as the foreign key. Is there a way that on each step I could redirect the customer the the respective state and also could Pre-Select from the pull down menu the company? The way that I'm doing the redirection for example to redirect the customer to the contact table is to enter in appgini on the "Redirect after insert" field as follows:
Event_Contacts_view.php?addNew_x=1
Is there a way to modify this redirection so it could automatically select the company name from the pull down menu?
How do I pre-select automatically from a pull down menu
-
- Veteran Member
- Posts: 90
- Joined: 2015-11-23 01:02
Re: How do I pre-select automatically from a pull down menu
Hi,
you can try to use
where FIELDNAME needs to be replaced with the company name field in your db.
you can try to use
Code: Select all
Event_Contacts_view.php?filterer_FIELDNAME=#ID#&addNew_x=1
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: How do I pre-select automatically from a pull down menu
To add, the #ID# must match the lookup id for the company name where you pick the name from. Not sure that this will work accross multiple tables.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
-
- Veteran Member
- Posts: 90
- Joined: 2015-11-23 01:02
Re: How do I pre-select automatically from a pull down menu
Hi,
It did worked on the first redirection to the second table but then stopped working after the second one. If you find out how to do it across multiple tables please let me know and I will send my gratitude from Paypal.
It did worked on the first redirection to the second table but then stopped working after the second one. If you find out how to do it across multiple tables please let me know and I will send my gratitude from Paypal.
Re: How do I pre-select automatically from a pull down menu
Hi,
send you a PM, but you did not reply. Maybe you can contact me via PM from your side.
send you a PM, but you did not reply. Maybe you can contact me via PM from your side.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
-
- Veteran Member
- Posts: 90
- Joined: 2015-11-23 01:02
Re: How do I pre-select automatically from a pull down menu
Hi,
Sent you the axp by link. Thanks,
Sent you the axp by link. Thanks,