ContributionsMost RecentMost LikesSolutionsRe: Combo Primary KeyThank You . Thanks a lot it worked ------------------------------ priyanka gummuluri ------------------------------ Re: Combo Primary Key I have marked orderid as unique and tried but still showing the same error message "This formula is incompatible...." ------Original Message------ Will your Order ID always be unique? If so, mark that field unique as well and then try marking the formula unique as well. ------------------------------ Michael Grosky Director of Customer Strategy, Sympo (Gold QSP) mgrosky@sympo.com ------------------------------ Re: Combo Primary Key ------------------------------ priyanka gummuluri ------------------------------ Re: Combo Primary Key Its showing an error . If i try it. ------Original Message------ ------------------------------ Michael Grosky Director of Customer Strategy, Sympo (Gold QSP) mgrosky@sympo.com ------------------------------ Re: Combo Primary Keyi want the field to be unique but if im trying the way you suggested me its accepting duplicate values as well. ------------------------------ priyanka gummuluri ------------------------------ Re: Combo Primary Key Im completely new to quickbase and can you please guide me in creating a primary key with two fields where the two fields are foreign keys ------Original Message------ The form rule method could also work, however a limitation that you could encounter is if you data is being entered via grid edit or import as opposed to using a form. ------------------------------ Michael Grosky Director of Customer Strategy, Sympo (Gold QSP) mgrosky@sympo.com ------------------------------ Re: Combo Primary Key Its still not working . I cannot set it as key ------Original Message------ You would need to create a formula Text field... in the formula section have something like: [Field A]&"|"&[Field B] You might need to add ToText() around the fields if they aren't text already... you then set this new formula field as the primary key of the table. ------------------------------ Ryan Stanford ------------------------------ Re: Combo Primary KeyPlease can you tell me how to create a combo primary key ------------------------------ priyanka gummuluri ------------------------------