ContributionsMost RecentMost LikesSolutionsRe: Rich Text Field:) Fortunately for you I'm addicted to solving native Quick Base puzzles.Re: Add a record to one table through a form in another tableSo One Artist has Many Events. Can you explain what you mean by this? "and have it update the Artist Table."Can you give an example of "update" If you want to have the details of the child record Events appear on the Parent Artist record, then there will have been a field created on the Artists table for the Events. The field type will be Report Link. put the field on the Artists form and select the form setting to show the Events on the form. Re: Relationship Diagrams-What are your thoughts?I agree w/ Laura (QuickBase Pros) that the pop up annoying when you are trying to untangle a complex app.It should drop off once you click outside its box.I would also agree with the crows feet, although I do not claim to have read Dan's 50 page pdf.Re: Link/button to open specific formno problem here is the formula urlroot() & "db/" & [_DBID_CUSTOMERS] & "?a=dr&dfid=XX&rid=" & [related customer] You get the [DBID_CUSTOMERS] which is the name of your Customers table from the Advanced Settings for the table. The dfid ("da form ID") is from the URL you see when you preview the form. Then you need to either feed it the record id ("&rid=" & [the field containing the record id of the customer]) or else you can also feed it a key field instead ("&key=" & [my key field])Re: How do I set up a one-to-one relationship between tables?If you have figured out how to link the two tables, you must have gone into relationships and made a relationship between the two tables.I assume that the field on the right hand side of the relationship is your project number field from the table A (and not the generic Related project number] field which would require you to maintain the links manually. Then just go to that relationship and on the right side you will see a button to add lookup fields. Use that to pull in any fields that you need from the parent down to the child.Re: How do I set up a one-to-one relationship between tables?Your parent table is table B and the child table is table A. In China they still mostly have a policy of one child per mother, but the mother is still the parent and the child is still the child, even though there is only 1 child per mother.Re: Send email to bccI doubt it, but its not like the QuickBase engineers consult me before they make a move.:)I really would nothave a way of knowing that, except that I have heard very few complaints on this forum about that, so I just doubt its a burning issue for them to address.Especially because the work-a-round of the Cut and Paste seems pretty painless to me.Re: Send email to bccNo, its a two step process. 1.Let them go to the TO field and then 2. Cut and Paste them into the BCC field, and put your own name in the To field.Re: Can I display a date field as YYYY-MM, where MM would be a two-digit rendering for the month?No problem, Try this var text YYYY = Totext(Year([SLA Date:])); var text MM = right("0" & totext(Month([SLA Date:]),2); $YYYY & "-" & $MM) This trick is to zero pad the month, so you stick on a leading zero and then take the rightmost 2 characters. so, 0 becomes 01 and 12 becomes 012 which gets trimmed to 12 when you take the rightmost 2 characters.Re: prevent duplicate records - combined keyNo problem Make a text formula field with the formula List("-",totext(Beer_id]),totext([Distributer_id]) .. and turn on the Unique checkbox for that field. call the field something like [Same BeerID - same Distributor ID] so that you error message is meaningful to the end user of your app. Try entering a duplicate, observe the red error message and edit your field name to make the error message instructive to the user.