I'm an advanced user and I haven't found an answer to this question regarding the "order" of fields in a table, as in which is the first field, second field, and so on. If I refer to the fields in a table as TableDef.Fields(0), .Fields(1), .Fields(2), and so on, what order are 0, 1, 2, etc. referring to? Are they the order of the fields as listed in the table design view? The topmost field is 0, second is 1, and so on? What if I move a field to another row in table design view? Will Fields(0), (1), (2), etc., refer to the new order, or the previous order, or the order when the table was first created (first saved?)?
Another question about the same issue is this. If I have an INSERT query (or Append query):
INSERT INTO Table1 SELECT value1, value2, value3, ...
What will happen? Note that I don't specify the field names. I assume this will insert value1 to field1, value2 to field2, and so on, where field1, 2, 3, etc., is this mysterious order of the fields that I can't figure out.
So can anyone shed some light on how field orders are determined in these different cirumstances (and perhaps others I haven't thought of)?