Database that calculate Due Dates

[wipidu]

I would like to create an Access Database that calculate due date based on 2 tables, one with invoices and supplier details. The other one with Supplier name et payment terms.

Input:
Table with the following details:
- Supplier Name
- Invoice Date
- Currency
- Amount



Output:
Table same as input but with a column that shows for each record the Due Date. The due date would be calculated by adding payment terms in days from another table to the Invoice date.

How should I do that?
Thank you in advance for your help

[June7]

Provide details on the other table. Is there a relationship between the tables, such as Supplier Name in both?

[wipidu]

Yes,
the other table will have only Supplier Name and Payment Terms:

Company A ; 60 days
Company B ; 30 days

The supplier name will appear several times in the first table with different invoices date for each line of entry.

[June7]

Build a query that joins the tables. Then the Payment Terms field will be available.

However, the Payment Terms field shows as text. It really should be a number field with just the days value.

Then can calculate the due date with simple addition: [Invoice Date] + [Payment Terms]

[wipidu]

Unfortunately, this doesnt work, i don't have any data.

[June7]

The ID field in Payment Terms is defined as primary key but you are linking on the Brand fields. Linking should be done with primary key field. So if you are saving the Brand value in Data table, Brand should be the primary key in Payment Terms.

Did you build Lookups in the Data table? I NEVER build Lookups in tables. http://access.mvps.org/access/lookupfields.htm

So what value is really being saved into Brand in Data table?