Search results for query: *

maybe this will help .. what I am saying is that t1 has a short set of fields containing basic data characterizing an entity .. t2 has a very long set of fields containing additional data about this same entity, but it does not duplicate any data in t1 (except for the ID code) that's the legacy...

after sending my message, I left the properties sheet open and went to get something to eat .. when I came back, the first thing my eye fell on was LimitToList .. all you have to do is set this to "yes" .. sometimes you have to ask a dumb question in order to find its answer, it seems

I have a field (fd87) where I want the user to choose A,B,C or D or leave it blank .. there are no other options fd87 has as its RowSource a table (t73), with the values A,B,C,D in it .. there is another field in this little table that contains data which in effect explains what A means, what B...

you're right, I gave the impression t2 duplicates the data in t1, then has additional data in additional fields .. I didn't mean to give this impression, however .. I want to avoid duplication let's take it as granted, though, for historical reasons, that I need two tables (t1 actually has more...

there are more items in t1 than I'd shown why is a third table needed? would it be possible/desirable to just make fm1 a subform in fm2, rather than anything more complicated?

table1(t1) and form 1(fm1) have field1 (fd1) field2 (fd2) field3 (fd3) table2(t2) and form (fm2) have fd1(same data as in t1-fd1) fd2 (ditto) fd3 (ditto) fd4 fd5 fd6 fds 7-59 fd1 is a unique-identifying-code there are 20k record in fm1 accordingly, there will be 20k in fm2...

table1(t1) and form 1(fm1) have field1 (fd1) field2 (fd2) field3 (fd3) table2(t2) and form (fm2) have fd1(same data as in t1-fd1) fd2 (ditto) fd3 (ditto) fd4 fd5 fd6 fds 7-59 fd1 is a unique-identifying-code there are 20k record in fm1 accordingly, there will be 20k in fm2...