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.

Redesign Issues

bdonelson
in Relationships

Featured Replies

Hello,

I am redesign a database, and I would appreciate any advice on these relationships.

I have started to connect the tables, but I have run into same issue I am redesign because of to begin with. As you can see in the attached screenshot, I have the "Stocks" & "Options" tables connected to the "Investments" table. I am attempting to use this "Investments" table to bridge the connection to the "Orders" table. I am the right track, or is there an easier way?

Thanks,

Bill

screen_capture.JPG

  • Author

More information on what I am attempting to do.

The problem being how do I lookup information on either table "Stocks" or "Options" in relation to "Orders".

Originally, I had these two tables as one, and of course the lookup was easy. But, I had a number of other relationship issues.

screen_capture_2.JPG

  • Author

That was a lot easier than I thought. All I had to do was use a calculated value instead of a lookup value.

Create an account or sign in to comment

https://fmforums.com/topic/45588-redesign-issues/
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.