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.

Trying the Separation Model

faada
in The Separation Model

Featured Replies

Ok, I've decided to try the separation model for the new multi-location inventory system I'm putting together, basically my data will be separated into 3 main tables, Location Master, Item Master, and Item/Location (which will house the actual quantities).

These are the fields I have in each table

Item Master: Item#, Description

Location Master: Loc Code, Description

Item/Location: LocCode, ItemCode, Quantity, UID (an auto-enter field which is the LocCode & ItemCode, there is a not equal self-join based on this field to ensure uniqueness based on both location code and item code at the same time).

Now, using the separation model I should have the layouts and scripts etc in a new file correct? Could someone give me a run-down of how the relationships etc should look?

Thanks in advance

Create an account or sign in to comment

https://fmforums.com/topic/24550-trying-the-separation-model/
Go to topic listing

Important Information

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

I accept

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.