Search the Community
Showing results for tags 'one to many relationship'.
Found 2 results
I am trying to create child forms and combine them on a single report details DataPage to enable data entry and updates into related tables that have a One-to-Many Relationship with the Main Data table. I got the idea from this YouTube video, except for the fact that I want to use Caspio direct links, not embed the child forms in an external page. The first comment on the YouTube demo is: ‘Is it possible to combine those without using an outside website?’ and the reply is “It is possible to combine them using Caspio's direct links, but that's something that our support team will need to show you.” I asked my point of contact via email and he suggested ‘You may try to deploy child forms (use iFrame deployment code) in the Header\Footer\HTML block of the parent form. To filter a child form you may use the option of receiving the ID parameter on a page on load. ‘ Sadly this doesn’t work. I have also tried to pick up the Id from the main page but that url shows as https://c4ffn695.caspio.com/dp.asp?appSession=76482739590823598589657321597597834513223740109360725456536771070521751291354582292557258285423955632065563132573471180313620233&RecordID=1113,5358,147,3,86,0,107,63,33,104,34,1,18,95,101&PageID=8&PrevPageID=2&cpipage=1&cbCurrentPageSize=25&Mod0LinkToDetails=True And the RecordID embedded in this url does not match the primary key in the Main Table. Does anyone have an easy implemented solution for my problem? https://www.youtube.com/watch?v=sgIaAeZxmy8
I wonder if someone found or came across a way to add an automated sequence number (for example, in the form of the current record count) to a child form based on a one to many relationship, for example each interested person for a specific house gets a sequence number from 1 for the first entry to n for the most recent entry. For another house the sequence start again at 1.