I'm a newbie ...

Have a simple database for submitting entries (IWP) for a gallery showing.

Fields are name, title of piece, size and price. Each person can enter five titles (with price and size). The titles, price and size fields are all repeating. I want to create labels for each title (with the artists name,etc.). I've used the get repeating field function to set up layouts for titles 2, 3, 4, & 5. This is ok unless a person has less than five entries; at that point my label layout is creating (wasting) a name label.

How do I create labels for only the titles submitted ... and leave out labels if repeating fields 2,3 and 4 are empty (for example)?

thank you

ps.

I'm not looking for a 'solution'; merely looking for guidance ... as in 'try a portal instead', or a key idea like the name of a function, or a calculation key.

thanks

Post deleted by 10000cranes

I would suggest thst you forget about repeating fields. They are a carryover from FMP2. Use a portal for data entry, it isn't that much different from repeating fields. You can limit the portal to five rows. When printing the labels, print from the related record.

You can create a compound calculation field which combines the various fields and uses the case function to handle the situtation in which any of the fields are empty.