Hi
I'm trying to combine both a facility address and mailing address to be next to each other. I'm currently only using 2 table to get it to work
The way that the tables are written is something like this
ID_S Desc
1 Fac Address
2 Mailing Address
3 Alt Mailing Address
4 Corp Address
The second table
CI Company Street City State Zipcode ID_S
1 Joe 12 Main Sr Cudahy WI 53221 1
1 Joe 34 North St Oak Crek WI 54312 2
2 Smith 56 West Av Milw WI 53215 1
3 Smith 78 Apple Milw WI 53214 3
Printout
Joe Company
12 Main Str 34 North Str
Cudahy, WI 53221 Oak Creek, WI 54312
What I want is to generate a bill showing both the Facility address and the mailing address. I tried to printout both the facility address and the mailing address without success.
One being a conditional function
FacAdd
IF ID_S = 1
THEN FacAdd = [Street]
FacMail
IF IS_S = 2
THEN FacMail = [Street]
When the user starts the program, they enter an invoice number which selects only one Company ID. Right now I get either the facility address or the mailing address,not both, or errors on my function.
Thank you for any help that maybe given.