Jump to content
  • 0

Many-To-Many Relationship Or Event Management Question


Stratz1081
 Share

Question

Hi All,

 

I have to create a simple database that tracks me member attendance on a weekly basis.  The event info is housed in 1 table and the members info in another.  I created a third table but not sure if I need it and would like some development advise on it.  The third table is simple an attendance with one field "Yes/No.

 

So my understanding of many-to-many relationship is that the 

 

1) Event can have multiple members and multiple Yes or No associated with those members

 

What is the best way to create this in caspio. Is there a many-to-many relationship function?  Is there a better way of creating this?

 

The basic function of this is to track the event date and if a member attend or not.  

 

Any assistance would be greatly appreciate 

 

Thanks

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0
Hi!
As far as I know, there are no many-to-many relationships in Caspio, most database management systems only support one-to-many relationships.
"There are two types of relationships: one-to-one and one-to-many relationships" (How-To).
 
And it seems, your way is the best - to create a third table with two one-to-many relationships.
And you probably know, that you can use a View to work more conveniently with the third table.
Link to comment
Share on other sites

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...
 Share

×
×
  • Create New...