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.

One table or two?

Featured Replies

I'm trying to decide if I need one or two tables for this issue.

I'm building a Billing/Inventory Tracking solution. A user creates Orders which have children named Bill Items. Those Orders also have children Contracts, which have children Transactions.

Bill Items look up Bill Codes and auto enter description, price, etc.

Transactions look up Inventory Items and auto enter description and current stock.

I'm trying to decide if Bill Codes and Inventory Items should be one table or two. For about 90% of the records, Bill Codes and Inventory Items are the same. But for about 10% of the records, Bill Codes are assemblies of Inventory Items (I have a separate table of Assemblies which would be a join between the Bill Code and Inventory TOs).

I can put Bill Codes and Inventory Items in separate tables. Or I can have Bill Codes and Inventory Items in the same table, and use a field that will have a value of Bill Code, Inventory, or Bill Code ¶ Inventory.

Any thoughts?

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.