PattyRod

Thanks! The value list I was using in the drop down contained a calculated field. I added blanks to the end of the calculated field to increase the size and it did the job of increasing the size of the drop down list box! Thanks again...

I have a drop down list that is reading from a value list. For some reason, the drop down list cuts off text on the right (the drop down box is too small). Previous drop down lists I've created have always been big enough to read all the text in the drop down list. Does anyone know how to control the size of the drop down list box? Thanks, Patty

I have created a report layout. I have one sub-summary part that displays the "one" record in a one to many relationship. The body of the report displays the "many" part of the relationship. Is there a way to have the sub-summary part print again at the start of the new page if there are still records that are carrying over to the next page? Thanks! Patty

Thanks John! I read through your links. The custom function is close, but unfortunately does the opposite of what I need. Maybe I should just post my problem and not ask about an outer join. Perhaps a solution can be found. Table A is a list of contracts that specifies data files we are entitled to receive. Table B lists all the data files we have in house. Table A and B are related by contract number. I would like for a report to show all contracts in table A and all data files in table B, but to also show any contracts in table A that do not have data files in table B. Ex: Contract 1 Data File A Contract 1 Data File B Contract 2 Data File C Contract 3 Data File D Contract 4 (no data files) Contract 5 (no data files) Any thoughts? Appreciate your help.. Patty

I am new to Filemaker Pro. I have some experience with Access. I just started a new job that requires me to develop a database with FM. I have the database created, but need to do an outer join for reporting purposes. Can I do an outer join in FM? Thanks! Patty R