Need better tracking with my tables

[raydan]

I have a DB thats working fine, but (there always is a but) I now need to do something a little bit different. I need to be able to track my originators and who they have brought into the company. So I will have an originator and many down-line originators, and these people that come in down-line will have people coming in down-line from them and so forth and so on. I have a table that has all originator info and originatorID, but will I need another table or can I just add to the exisisting one. Here is the table structure:

‎Originators:
-------------
OriginatorID -autoNumber
FirstName - Text
LastName- Text
OrigSSN- Text
Address- Text
City- Text
State- Text
PostalCode- Text
HomePhone- Text
WorkPhone- Text
CellPhone- Text
FaxPhone- Text
EmailName- Text
BirthDate- Date/time
Level- Text


If more info is needed please let me Know.. Thanks in advance.

Scott

 

[raydan]

Ok, this makes sense to me but i'm having trouble implementing the idea. I added the line UpLineOrig to that table. I save it then, open relationship table and I join the OriginatorID to UpLineOrig. Is this what im suposed to do because the results aren't correct. I get a sub-table that copies exactly what the Originators table to Originators_1. I guess im not sure how to join to entries in the same table.

 

[raydan]

Wow, there is this beautiful tab called lookup. I used that and guess what it worked, thanks for the help. But before i call this done, will what i just did work because I didn't have to join anything in the relationship window. I'm concerened that this won't work. Now it looks like this:

‎Originators:
-------------
OriginatorID -autoNumber
FirstName - Text
LastName- Text
OrigSSN- Text
Address- Text
City- Text
State- Text
PostalCode- Text
HomePhone- Text
WorkPhone- Text
CellPhone- Text
FaxPhone- Text
EmailName- Text
BirthDate- Date/time
Level- Text
UpLineOrigID- Number(with lookup set as;
display control-List Box
row source type- table/query
row source- Originators)

???? Now there is just this table and no others to join, is that correct?

Scott