I am a french guy, so please excuse my poor english. My filemaker is french  so I don't know what are the real words in script. Finally, this file is about billing, but please do not consider the bill itself but only the script.

So for the billing, I use 4 tables
- Job table
- Internal jobs (for hours and rate)
- External jobs (for supplies)
- Billing

These 4 tables are linked by the filed id_job.

So this is how it works. When the client accepts the quotation, i edit the deposit invoice. When the job is finished, I edit the final bill.

The problem is that the script does not work correctly.
The 1st script is for the deposit invoice. Il creates a new bill (FACT-01) wich mentions the advanced payment
The 2nd script generates the final bill (FACT-02). It must contain details of the bill. But the bill does not contain the details; Worth, the details are injected on the deposit invoice ((FACT-01)

The reset script is to... reset the database

So is someone can explain me what is my error in the "bill script"

You can find the file attached. Please look at the script and tell me the error

Thanks

V.

 

 

Linked tables.fmp12

Hey,

Come on private message

Hi everyone,

After some discussions with

The "problem" is that four tables are linked by ID_JOB.

In the script, if you use display related records and then fill the field with define field ... you always will fill the same record (the first one in this example)

At the first bill, no problem, but when creating the second, the link doesn't work well.

So after displaying internal job, you have to display billing for working on the last record and then you can fill it.

Hope it's clairful.

Tom