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!!