Question# 1

OK this question may be already asked by someone but I'm new to access a bit unclear on solution.

I want to my database to assign unique id for each set of 10 Column & 9 Rows - is this possible? with support of further calculations based on the said set of data (like get sum column 6 against of all XYZ values in column 1 etc. etc.).

OR should I go with 90 columns instead to accommodate the said group of data? which option is best/preferable?

Note: variable number of rows out of above mentioned 9 rows data set will remain blank additionally I'll require one yes/no filed against each group of data.

Question# 2

I have a linked ODBC table, using VB how can I make it auto load plus add new record to specific fields only then set yes/no filed, in another table, to yes?



Thanks!!