Adding an input field to a query

[p3rlend]

I have a table A and a table B, both with index columns and text columns.

#A	NameA
1	A1
2	A2

#B	NameB
1	B1
2	B2
3	B3

Now I use the Select Query to get the product of these tables:

NameA	NameB
A1	B1
A1	B2
A1	B3
A2	B1
A2	B2
A2	B3

What I want in this table is a third column where I could type in new data, such as 0 or 1, or any other data. How can I accomplish this and still keep the table dynamically updating if I add new records to the table A or B?

Thanks in advance!

[ranman256]

turn your query into a make table, and add an empty field: MYFIELD:0
then you can set your settings

[p3rlend]

Thanks for your reply!

If I make a table with an extra "empty" field, and then fill in the input values in the new field, the typed inputs would be erased if I want to update the tables A and B. Or, I would create a new table each time I update the records in tables A and B. But that seems a bit cumbersome.

Perhaps it would be possible to make a form that creates a many-to-many table?