We'll need to know more about your database and relationship between the tables to fully fgiure this out with you.
To start, what is your primary key in service master? Do you have an auto-entered serial number for this?
Describe the relationship between your two tables.
"I cannot enter any other information (address, city, state, zip)"
What layout? what's the underlying table?
I would think that you want a layout based on Fleetmaster, setup in Form Mode, with 1 record per customer, and a portal on that layout, based on Servicemaster. That way, if a customer is new, you can quickly enter the information into the fields in Fleetmaster, and on the same layout, enter the details into the Servicemaster portal. You could even then switch to a Servicemaster layout, where additional info can be entered for the service record.
The primary key is in Fleetmaster and is auto generated, field name is custnum.
I am guessing at what you want for the relationship connections. The field that
is connected is custnum. The fields that have been joined/linked via field control
setup etc. are customer name with drop down, address, city, state, zip. There will
be four additional fields after I get this figured out.
The customer name field allows me to enter a new customer name, but none of
the other fields do.
So you have a relationship that looks like Fleetmaster::custnum = Servicemaster::custnum or something similar? Do you have "Allow creation of records via this relationship selected" for the ServiceMaster table?
Etripoli has recommended a good basic layout design for this purpose. What layout have you designed?
customer name, address, city, state and zip are all fields that should be part of the same table and entering this information should be no more complicated than creating a new record in that table then then typing the data into each field in turn.
Which table are these fields are part of, and to repeat myself, how have you set up your layout?
Oddly enough you work with the tools long enough and serendipty occurs along with luck.
I deleted the customer name field and recreated it and everything works just fine.
Thanks to all that posted their ideas.