Drop down parameters values pulled from another table

[grriii]

I am trying to figure out how to create a drop down populated with values from another table. I have one form in which a user (let's say User 1) can enter up to 4 pets. This form is called Client Profile and is the authenticating table. I have another form that needs to have a dropdown that pulls those 4 values (or less depending on how many were entered) based on User 1 being logged in and filling out the form. Any suggestions? Thanks in advance!

[MayMusic]

if you want to pull up the pet's name in a dropdown then you need to create one record for each pet in user_table.

These are the tables you need:

User_tbl: User_ID, UserName, Password, NumberOfPet

Pet_tbl:Pet_ID, User_ID

User will register first in a submission page based on User_tbl, then they will login to an authenticated page based on Pet_tbl. This page will receive the user_ID from authentication table (User_tbl) so we know which pet belongs to whom.

You can limit the number of submission each user have for pets (4). Here is the tutorial : http://howto.caspio.com/customization/limit-the-number-of-maximum-submissions.html

:wink: :wink: :wink: :wink: :wink:

[grriii]

Thank you MayMusic! I have another related question. I have more than one pet record for a client. I want to give the client the option to update the pet record - how would the client select the pet he or she wants to update?

[MayMusic]

You can create an authenticated report form and have the client login to the report page. This way you can enable record level security to pull up the records (pets) belong to this client : http://howto.caspio.com/authentication/record-level-security/restrict-access-to-records-by-user-or-department-etc.html

Then he can select the per from report page and go to the details to edit it: http://howto.caspio.com/datapages/creating-datapages/creating-a-search-and-report-datapage/update-records-using-a-details-page.html

[grriii]

Wonderful, thanks!

[MayMusic]

You are welcome!

[NailDyanC]

Hi, just to update this post. Here are the new and updated links you can use:

Limit the Number of Submissions:
https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-limit-the-number-of-submissions/

Record Level Security;
https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/
https://howto.caspio.com/getting-started/record-level-security-stamping-new-records/

Creating a Report DataPage and use details page to edit:
https://howto.caspio.com/datapages/reports/creating-a-report-datapage/