Analyze Performance Tables

[RustyRick]

When I run the "Analyze Performance" on my Tables I get a suggestion to change a Primary Key to "Long Integer".



I have it as a number but I chose the Data TYPE to be "Short Text".

1: Is that a correct suggestion?

2: I can't find "Long Integer" in the Data Type. Does it mean "Large Number"?

[June7]

You choose Number type then below in Field Size property select Long Integer

But why not use autonumber type as primary key?

[RustyRick]

I have no clue why NOT to use Autonumber? I have 13 tables. and to use AutoNumber without a descriptive name, I thought confused me. Am I going down the wrong road?

[June7]

Can give autonumber type field any name you want, for example: CustomerID_PK

Then related Number type (LongInteger) foreign key field in dependent table (such as Invoices): CustomerID_Inv_FK

[RustyRick]

Hmm Thanks I'll re-visit that. I'm too old to be doing this. i've forgotten so much. Thank you!!!

[RustyRick]

I guess I have about 7 tables with only 1 field. I did that so I can facilitate ComboBox drop down lists. So my PK was descriptive TEXT and "Short Text".

The 7 tables with only 1 FIELD are the result of un-calculable combinations or variable of the data. I have spent days trying to figure a better SIMPLE way of covering that. But I see no option.

[June7]

Okay, saving text instead of number key uses up more storage space and indexing on text field is slower than on number type but it will work.

Numbers saved and treated as text will not sort properly. "10" will sort before "2" as opposed to 2 will sort before 10.

Never too old to learn. Says one who returned to college at 45.