ContributionsMost RecentMost LikesSolutionsOpen record in another form and change the value of a fieldHi I'm trying to add a button which will open the same record in a different form but at the same time editing a field within that form. i have this so far which opens the record in the other form but what i cant figure out is how to add in the piece which will edit the checkbox field to true. The checkbox field id is 155. URLRoot() & "db/" & Dbid() & "?a=er&key="&[Record ID#]&"&dfid=11" Any guidance would be appreciated ThanksRe: How do I push Quick Base data into Quick Books Online?I use Workato regularly with Quickbase, if you need any help give me an email and i'll see what i can do. ashley.corbetta@ingramcontent.comRelationship between Table A and B without using Primary Key on table AHi I have a table called Leads. The primary key on this table is the "Record ID#" field. Leads eventually open accounts and the Lead records "Account Number" field gets updated with the account number of the account they opened. Im trying to build a relationship between the Leads table and Sales table. the Sales table contains the account number that places orders with us, the relationship needs to be between the Account Number field on the Leads table and the Account number field on the Sales Table, neither of these account number fields act as a primary key. Is there a way to do this? Essentually i want to be able to have fields on the Lead table showing the number of orders placed and total sales number taken from the sales table. ThanksRe: Line and Bar Graph - Can we put the Line and Bar on the same axis?Hey sorry for the delay in getting back and thank you for your response. I am aware of how to get to the line and bar graph report type, my question is instead of the Line going on a "primary" Y axis and the Bar going on a "secondary" Y axis can they both be put on the same axis. Essentially what I want is for the axis scaling to be the same for the bar and the line. At the moment they are different, even when i use the same numerical field for the line and bar.Line and Bar Graph - Can we put the Line and Bar on the same axis? Hi - I'm looking to create a Line and Bar graph where the line and bar use the same axis. Is this possible? Seems to me there is no option to use the same axis only the option to use a line and bar on separate axis. Thanks