Jump to content
  • 0
Sign in to follow this  
grriii

Drop down parameters values pulled from another table

Question

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!

Share this post


Link to post
Share on other sites

6 answers to this question

Recommended Posts

  • 0

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:

Share this post


Link to post
Share on other sites
  • 0

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?

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites
  • 0

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...