Stupid Table Q, but still need ans

[LiquidMetal]

Hi

I have a table called tblPMDP

PMDPID (PK autonumber)
PMDID (FK)
CostTypeID (Number)
CostType
ProcessPrice
UNID (Number)


What I want to do is to get:

PMDID & CostTypeID

into UNID as soon as the table receives both values

By combining these 2 values I get a unique number which I want to use to limit duplications. The PK is no good as each event is unique whereby I want to be able to use PMDID for other purposes too.

I have made UNID an Index with unique = yes. but it does not populate.

I also tried using an append query but it adds the values in addition to the values already into the table.

Thanks

 

[Alansidman]

Do you have a form for entering data? In your form for the control you could put

=PMDPID & PMDID

If you are not using a form, then an update query (not an append) should do the trick.

Here is a link on how to make an update query

http://www.databasedev.co.uk/update_query.html

Alan

 

[gordonf35]

I am looking for this problem as well, please help!