Jump to content
Sign in to follow this  
d3adm8n

Membership Database

Recommended Posts

Hi,

I'm having some problems with a Membership database that I'm trying to create.

The table includes a Date field, with a "Days Attended" input field. I need to be able to save this information each week for any selected member and for that information to be stored for later retrieval.

Secondly, I have a "From" Date feild and a "To" Date field. I need the table to be able to calculate the "Days Attended" from my selection of the Date in the "From" and "To" fields. This action needs to be spanned across multiple records.

How would I go about doing this?

Thanks,

Sam.

Share this post


Link to post
Share on other sites

You need a related table to store the dates attended. Use a portal in your main layout to view these dates. You can also enter the dates through the portal.

Share this post


Link to post
Share on other sites

Thank you. Sorry for my very late reply. I have created another table which I consider the backbone DB, that will hopefully store the information that I provide through my main table, how It's going to do this, I don't know.

I have attempted to make the main table and the database table related by cloning certain fields from one to the other in hope that it would work like that.

Also, when it came to me trying to implement a portal it fell a bit flat. I added a portal to my main table, but all it seems to do is distort my layout. I know that It's meant to be used for more and in some way, but I don't fully understand how.

As you can see, I may need a lot of help.

Thanks,

Sam.

Share this post


Link to post
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
Reply to this topic...

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

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.