If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Recordset with data joined from 2 tables?
Hi to all the Gurus out there,
I originally developed a database for keeping record of registered competitors & their matching as competitive couples. Now I'm developing a database for recording the points earned at competitions & I use the same back end from the Register database. My difficulty is dealing with couples who are not registered with our organization. I've started by getting the registered couples data & points calculations working correctly. Now I need to incorporate the non registered. I need to keep record of them as I also need to know how many couples competed in an event. The registered couples have a number which they use for the year which I use in a cbo box. The non registered get a different temp number at every competition. The temp number will never be in the database at the time of data input as it is +- 100 greater than the highest registered number. My couples number is a text field. Now if I lookup the couple in the cbo they are not_in_list (obviously) & I've coded the "don't add" part of the event. The "non" competitors are in tblNonCompetitor & their couple matching is in tblNonCouples. Now comes the scary part... Best solution to go forward bearing in mind that a non registered couple may join our organization during the year & be assigned their own permanent number. Any pointers, suggestions how I should best deal with this will be sooooo appreciated |
Thread Tools | |
Display Modes | |
|
|