Problem with composite keys /Generic keys

[Anonymous]

Initially I have the following design

To avoid generic keys I create composite keys in both tables Budget and TempSales as follow

"Code Site"&'|'&"Code Structure"&'|'&  'O'&'|'&    Date(Date#([Date Time],'YYYY-MM-DD'),'YYYYMMDD') as BudgetId

Now I didn't get the best values of budget , How to resolve it ?

[Anonymous]

"Code Site"&'|'&"Code Structure"&'|'&  'O'&'|'&    Date(Date#([Date Time],'YYYY-MM-DD'),'YYYYMMDD')

Is your BudgetID unique?

[Anonymous]

no not unique

[Anonymous]

Make sure it should be else you may get wrong data as well

[Anonymous]

how to make it a unique key please ?

[Anonymous]

For that post some sample data of Budget & TempSales table...