Hi everyone,
thanks for having a look at my problem. This is my first post so I hope I'm clear in explaining this.
I have 2 tables and a form.
Table1 = master
Table2 = subtable
There are 3 parts to this;
1.
I want to compare two fields to automatically input into a third field.
For example if FIELD A = FIELD B(+/-1), then FIELD C 'yes', 'no'
2.
There are 16 rows in which I would like this to work.
If 5 or more of these rows have 'no' in FIELD C, then I would like that the 'no' entries are highlighted red.
3.
FIELD B is a list of entries in Table2 and at the moment I am only able to see them on the form (and in Table2). Do I need to find a way to autopoulate the selected entry into the Table1 entry for this comparison or can I do it with the FIELD B info on in Table2?
The entries in Table2 can relate one-to-many.
I've been looking for a wee while for ways to do this and haven't gotten very far. I've been looking at writing a Macro to do this. I think this is the best way? I found something online about using SETFIELD but the option doesn't come up on my computer.
Thanks for taking the time
Will