nati Posted March 21, 2001 Share Posted March 21, 2001 I have a program - clients/ invoice/ line items/payments. I just added a insurance file that relates to client file. it has a join file. Client has a primary insurance company and secondary. What I would like to do is in the invoice file show the clients primary insurance company. What relationship do I have to setup to show this or what's the best way to do this? It's driving me nuts! many thanks, nati Link to comment Share on other sites More sharing options...
LiveOak Posted March 22, 2001 Share Posted March 22, 2001 In the insurance file, you need to create some way of differentiating the clients primary insurance carrier from the secondary carrier. To do this you will need to create a composite index: Type (text, indexed) values "Pri" and "Sec" InsIndex (calculation, text, indexed) = ClientID & Type In the invoice file create a similar index field, but specific to primary insurance: PriInsIndex (calculation, text, indexed) = ClientID & "Pri" Relate PriInsIndex (invoice) <--> InsIndex (insurance) and display the related fields in invoice. -bd Link to comment Share on other sites More sharing options...
nati Posted March 24, 2001 Author Share Posted March 24, 2001 thanks live, i'll give it a go! nati Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8456 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now