one-to-many relationship

[wrpatterson]

I'd like to be able to add multiple connections between a record in one table and several records in another table.

For example, when I record an entry in my master table, I may need to add multiple submitter names that are each separate records in the name table. Currently I can link only one name to each entry in the master table.

[ChrisJ]

See this topic: http://howto.caspio.com/parameters/in-a ... pages.html

Does this answer your question?

[JolliBeng]

Hi wrpatterson,

The first step in creating a web-based application is to build a normalized table. You need to make sure that the tables are well-architected accordingly to the needs of your application. You can click the links below to view the presentation 
Introduction to Table and Table Design  
Data Normalization: https://www.youtube.com/watch?v=oexOYUUyQik    
One-to-Many Relationships: https://www.youtube.com/watch?v=IstAk982ntA  
Many-to-Many Relationships: https://www.youtube.com/watch?v=7D8u6Lb2BKU  

 

-JolliBeng