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

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Creating Estimates

Followers

November 2, 200619 yr

Newbies

Looking for a start with relationship structure.

Table A. 15 Categories, ID & Name. A category can have 10 to 15 details, it will always be the same number and type of detail.

Table B. 25 Details, ID & Name.

Each Detail has sub-details with prices.

Ideally, when a user selects an estimate category from a value list and clicks on an (enter details) button, he will be on a layout where all the category details are listed and the estimate quantities can be entered.

I've considered portals for the quantity entry to a join table, but fear that at times some of the line items for a complete estimate would be missed without a reminder list.

Also, I was going to have a separate Sell Price Table with ID, Name & Amount so that Price adjustments could be easily handled by the user.

I'm completely open to any suggestions and do need a kick in the right direction.

Thanks,