Forum Discussion
Hi and thanks for the response.
I had a go at what you suggested but am struggling. Perhaps I need to spend more time watching the tutorial video�s to grasp the basics.
In my current App I have the following Tables / fields:
Materials:
� Material � selectable list
� Shape � selectable list
� Size � selectable list
� Bar length - numeric
� Cost / bar - Currency
� Cost / meter � Currency (formula)
Process Costs
� Process Group � selectable list
� Process Detail � selectable list
� Labour rate (�) � Currency
� Process Time (mins) - numeric
� Standard cost- Currency (formula)
As you suggested, I then created two new tables, one called Estimate and one called Material Estimate
Initially I created no fields to either table beyond the default ones created by the system. But I then created a field in Estimate Table called �Unit Material Cost (look up)� as suggested.
I then added a one to many Relationship in the Estimate -Table to The Materials table.
The fields in the Master Table - Estimate are: Record ID (key field), Materials (report link), Add Material (URL formula). The fields in the Details Table � Materials are Cost per meter (numeric-reference) and I added the lookup field called �Cost per meter � Unit Material Cost (lookup) � numeric (reference proxy).
I saved and came out and then went into the Estimate Table to see what I had.
The Estimate Table now does something. On the Home Page for Estimate I see a table that has the following data columns: Unit Material Cost (lookup) , Materials (with a hyperlink titled Materials), and a Add Material (a button).
When I click the Add Material button it opens a new data entry form to the Materials table allowing me to create a new material record.
At the top right of the home page there is a green button called �New Estimate�. When I click I get a form with a box that says Unit Material Cost (lookup) and I can enter values to this.
Below this I see a button for Add Material. This again is a new data entry form for creating a new material record.
So it is doing something but I don�t really get what it is doing or how I arrived at it.
I think what I am missing is a clear picture of the overall schema of the database in terms of what tables do I need? What fields in each table? What relationships between tables? What lookup fields to place in the �Estimate� table.
Even with the experimenting I have done I can see the tool is capable of what I am trying to do. I just can�t get at it.
Can you suggest which of the training videos should I go over to grasp the basic concepts more firmly?