Relationship question

[tobbesfilemaker]

Hello, I have 2 tables Orders and Costs. in the cost table I have 2 fields "description" and "hours" Now 1 order can have many costs  ( one to many relationship  ).

 

When I create a post in the table order I want it to automatically create a post in costs and set the field "description" to the textstring "workhours" and I want the hours field to automatically update from a field in the order table, so when the field in the order table changes, then  the field "hours" should change to.

Now the trick is I also want to be able to create more posts in the costs table and write what I want in the field description and hours. 

 

If "hours" is a calculation field it works with the update but then i obviously cant write in it, if its a text field with a calculation that takes the value from the field I want it doesnt update..

 

I really appreciate help.

[Rick Whitelaw]

If the field "Description" Always has the value "Workhours" why not simply have the field be "Work hours" and fill in the number? Maybe I'm missing something. Do you have a PK auto-entered serial in Orders table which becomes the FK in the costs table?

Rick.

[macavity]

If you use a calculated value in the text or number field, it will update if you remove the tick from the Do Not Replace Existing Value... box. The problem is, if you've written something else in the fields that you want to keep, it will update to the modified value in the orders file - and overwrite your entry.

...if I've understood your question correctly.

[tobbesfilemaker]

The field description is not always work hours, just one post is called work hours. when I create new post in the cost table I want to write other things in both fields.

 

So simply put.. ( I`ll try atleast )

When I create an order I want it to automatically create a post in the cost table and set the description field to workhours, and the field hours should take its value from a field in the order table which updates all the time. And while this is going on I want to be able to create more posts and write what I want in both description and hours field. So 1 post kind of updates as a field in the order table updates while I want to create more posts. Hope u guys understand and thanks so much for answers:)