jstrack

I would like to validate a two field combination to ensure that no duplicates are allowed. For example, one field is a color and the second field is an object (i.e. Red balloons, Orange Hats). This is straight forward for one field however, I cannot find a way to accomplish this with multiple fields. If I try to create a combo text field using the calculaiton method only the first field is displayed. I cannot find a way to validate a calculation field as an alternative. Thanks much

I would like to generate a value list using different fields (i.e. I have a field for Father, Mother and Guardian). How can I have all three fields available for a value list? Thanks much.

I have a problem with a Database when I open it under windows. The screen does not stay maximized. I need to set the screen to maximize every time I open the DB. Does anyone know of a method to force the screen size to open maximized under windows?

I have a need to display only a specific row of a portal (i.e. the second or third row). Is there a command that can do this? Thanks much.

Thanks for the help. This solved my problem. This has created a secondary problem being that the Teacher/Class combination I am using as a relationship for taking attendance. By using the calculation method as suggested it no longer allows for the use of the Teacher/Class combo as a valid realtionship since the combo cannot be indexed. Ideas??? Thanks again. Two problems to go and things are looking up. quote: Originally posted by jstrack: I use a DB to create a list of classes that I teach. A second DB is a list of students with misc info on each including the classes they are taking. If I make a change in a class or correct a typo the student files are updated and everything is great. A third database tracks detentions for students. I want the class to be included in this DB. The class information will not show up. Is this an issue with FMP? I generally use Access where there is one DB and multiple tables. If this is a restriction in FMP I need to rethink my DBs. Thanks in advance.

I have two DBs. One contains classes That I teach. Each record has an ID# and description. My second DB lists my students and the classes (five) that they are scheduled to take. My relationship is the Class ID# between the two DBs. I don't seem able to display multiple classes for a given student. I can select different classes however, only the first classes description appears in each of the five fields I ahv set for classes. Suggestions would be most welcomed. Thanks in advance.

I use a DB to create a list of classes that I teach. A second DB is a list of students with misc info on each including the classes they are taking. If I make a change in a class or correct a typo the student files are updated and everything is great. A third database tracks detentions for students. I want the class to be included in this DB. The class information will not show up. Is this an issue with FMP? I generally use Access where there is one DB and multiple tables. If this is a restriction in FMP I need to rethink my DBs. Thanks in advance.

I am new to FMP and I am having problems with relations. I have four DBs. One contains information about user (Name, Address, etc). The second contains information about the vendor (Name address, etc.). The third contains information about sales using info from the other DBs. The fourth contains a list of Cities, States & Zips). I have ID numbers for each record in the City/St/Zip file as well as the User and Vendor files. The city/state/zip in the User file is displaying the City/St/Zip combo using a popup list and the relationship. Every time I change the spelling of the city/state/zip everything works great. Now when I create a record in the sales DB it brings up the user info and will correct any changes I make to the user DB. Again this is great. However, I cannot get the sales DB to display the City/State/Zip information from the User DB. Any ideas would be appreciated. I know this is long-winded. Thanks much in advance.