Announcement

Collapse
No announcement yet.

Inspiration: Member - Management

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Inspiration: Member - Management

    Hi,
    I have a little problem to tackle. With scriptcase, I am not yet 100% sure which way to approach and have now hoped for some guidance or basic ideas.

    The following scenario takes place: I have some members of our club who regularly pay a monthly fee. If they don't show up however, they don't have to pay for a month.

    Thus I have 3 tables:
    - A member table (ID, Membername, ....)
    - A fee table with all bookings regarding the members with a foreign key to the member table
    - An exemption table with a foreign key on the member table and a second column with the month (format YYYY-MM).

    My goal is to fill the third table in an elegant way where I can choose a member and add a new exemption but also to see and edit previous entries.

    I suppose I need a grid first with showing the exemption table (with a relation to the members) and to have a master / detail form for editing and adding data.
    Do you have another approach? Is there an example out there among those plenty demo scriptcase applications?

    Thank you and best regards,
    Konstantin
Working...
X