Date field as primary key

(0) Share

Report

Posted on by SII1MNL

1,295

Hi,

I would like to ask a question. I hava a new table (e.g table1) and it only have transdate qty and cost value fields and the other one is invent trans table which I need to get the values and cost according to transdate I selected. this form is for the inquiry. can I set the transdate as primary key to generated data from inventtrans to table1?

thank you.

Ivan

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Martin Dráb 237,882 Most Valuable Professional on at

Like (0)

Report

Yes, you can use date fields in primary keys. Just try it and see for yourself.

Was this reply helpful? Yes No
SII1MNL 1,295 on at

Like (0)

Report

Okay Martin, I will try. Thank you.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi SII1MNL,

If you set the date as a primary key, if there is multiple data for single date how it will pick the data from Invent Trans uniquely.

you can try as Martin said.

Thanks

Was this reply helpful? Yes No