Calculate date based on other table

[EMILYTAN via AccessMonster.com]

Below are my 2 tables:-

Table1
ItemID (primary key)
Days

Table 2
Serial number(primary key)
ItemID
dateExpired

I need the dateExpired to be auto calculated when I enter the ItemID. The
dateExpired is today's date + the days in the table 1...May I know the way?

 

[Guest]

It would be a good idea to create an index for the ItemID field in Table 2

You did not say whether there is a form involved of if you are doing
recordset processing or if this is being done in a query. Where you are
doing this will determine how you do this.

Post some additional detail, please.