Formula User
I have a quotes table and a dealers table. The Dealers table has all of their contact information for each specific dealer.
I also have a formula User field that is just identifying which user is ...
Forum Discussion
Mike,
If I understand rightly, this is how your structure is :
Dealer - Parent Table
Quotes - Treat this has child . One dealer having multiple quotes. You users are basically the dealers who will be using generating quotes.
1) On the dealer table, make sure Dealer User ID (User type) field is unique and primary instead of default Record ID#.
2) On the quotes table, create a formula user field e.g. [Current Login User] = User(). This always populates the current user who logged-in
3) Create a relationship between Dealer (Deal user ID) and quotes (Current Login User)
4) create lookup fields from dealer to quotes.
5) Place the current Login User on the form , followed by lookup field. Make sure that "Current Login User" field is placed on the form.
This should get you dealer information for logged user.
------------------------------
Babi Panjikar
------------------------------
If I understand rightly, this is how your structure is :
Dealer - Parent Table
Quotes - Treat this has child . One dealer having multiple quotes. You users are basically the dealers who will be using generating quotes.
1) On the dealer table, make sure Dealer User ID (User type) field is unique and primary instead of default Record ID#.
2) On the quotes table, create a formula user field e.g. [Current Login User] = User(). This always populates the current user who logged-in
3) Create a relationship between Dealer (Deal user ID) and quotes (Current Login User)
4) create lookup fields from dealer to quotes.
5) Place the current Login User on the form , followed by lookup field. Make sure that "Current Login User" field is placed on the form.
This should get you dealer information for logged user.
------------------------------
Babi Panjikar
------------------------------