Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Need help with table structure

Featured Replies

New to the forum but have been using FMP for years. Please advise if this posting should be located elsewhere in the forum. Thanks in advance for any help offered.

I am building a DB to process registrations (200 records) for an event with activities over 4 days.

I need some help with how to design the necessary tables to make it do what it needs to do.

Registrants (Winners) can optionally bring one Guest and both Winner and Guest will register for one activity each from a choice of 20 events offered each of the 4 days. Each of the 20 daily activity choices needs to have its own inventory maximum.

As registrations are processed, the inventory will need to be reduced to prevent over-booking the activity. Both Winners and Guests pull from the same activity pool for a given activity on a given day.

Attached is a mockup used to demo to the client how the DB would look and operate.

Thanks again for any help you can provide on determining the table structure.

registration_process.jpg

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.