It seems like this should be easy but I am so confused.
I have two tables. The NAMES table has a NAMES Field and a SEQUENCE field that is a formula field that calculated how many days ago the record was created. Therefore, The SEQUENCE Number for a record increases by 1 each day.
The MESSAGE Table has a MESSAGE# field with 100 records numbered 1-100 and a text field called MESSAGE.
I am trying to make them related fields so I can see which people from the NAMES table have the same SEQUENCE # as the number in the MESSAGE# field.(so the associated records for a MESSAGE Number will change each day).
If it makes any difference, I will be using this to automate sending out SMS messages but am stuck with the setup for some reason/
Any help is appreciated.!