Selecting Individual or Company data for invoices

[AndyCan]

Good morning everyone. I have what is probably a very basic question to answer, but i'm a bit confused as to where to start.

Basically i am developing a small db to manage freelance design work, with projects, project stages, clients (individuals or companies) and an invoice functionality.

My question is: How do i automatically populate the client details in the invoice when the client could be either a company or an individual. I would like to separate companies and individuals into two different tables and not just mix everything into a single client table.

For example, supposing i could figure out a way for the database to detect whether my client is an individual or a company - possible with a radio box - how would i then selectively populate the information in the invoice. A company will have a registration number, whereas an individual will not. Is it possible to also use conditional labels that do or do not appear based on the type of client?

Thanks for your help! If this has already been addressed in another post, please forgive me for not having seen it and pass me a link.

Andy.

[AndyCan]

To follow up my previous question, I found a useful method in another post that involves setting up labels with calculation fields using text concatenation. So now i have two calculation fields - one with all the company details as they would appear in an invoice and another with all the individual details as i would like them to appear.

Now it's just a case of placing one of the two fields in my invoice. I'm still not sure how to do this. I thought of having two different invoice templates, but that doesn't seem to be a very elegant solution.

At the moment i have both company details and individual details in a single CLIENT table and a radio button with a boolean value stating whether it's a company or not. I still think it would be better to normalise this and have separate INDIVIDUAL and COMPANY tables and maybe populate the CLIENT table with the appropriate foreign keys.

At least for now i have found a more elegant way to add just a single field to the invoice with all the label information, but i would still appreciate peoples thoughts on the general structure and if i'm going in the right direction or not.

Thanks again!

Andy.

[Fitch]

You could use conditional formatting to hide/show the appropriate fields, or you could put each field on its own tab panel and go to the right tab when you go to the layout -- ideally with a script trigger, but your profile says FM9.

If you're calculating the label though, why use two fields?

Case( Boolean ; company label ; individual label )

[AndyCan]

Case( Boolean ; company label ; individual label )

Many thanks Tom. That was exactly what was needed. Now i just have one single calculation field with a case function that chooses the correct texts for the label depending on whether it is a company or and individual.