ContributionsMost RecentMost LikesSolutionsReport LinkI have a Report Link in Table #1. I want to have the same Report Link in Table #2. They have a relationship, but it's not on the list for Add Lookup Fields. How do I get the same Report Link in #1 to #2? ------------------------------ Mike McCartney ------------------------------ Re: Multi level formulaThis is great Austin. Thank you! ------------------------------ Mike McCartney ------------------------------ Re: Multi level formulaI believe I got it: ((((([Pass Comp]/[Pass Att])-0.3)*5)+ (((([Pass Yards]/[Pass Att]))-3)*0.25)+ ((([Pass TD]/[Pass Att]))*20)+ (2.375-(([Pass INT]/[Pass Att]))*25))/6)*100 ------------------------------ Mike McCartney ------------------------------ Multi level formulaI want to calculate the NFL QB Passer Rating, but not sure best way to do this. Here is the explained process: Formula 1:Take the completions/attempts, subtract .3 and multiply the result by 5. Formula 2:Take the passing yards/attempts, subtract 3 and multiply the result by .25. Formula 3:Take the touchdowns/attempts and multiply the result by 20. Formula 4:Take 2.375 minus the result of interceptions/attempts multiplied by 25. After calculating each of the four formulas, there is one final formula required to generate your passer rating: NFL Passer Rating= The sum of the results of Formula 1, Formula 2, Formula 3, and Formula 4 divided by 6. That result is then multiplied by 100. ------------------------------ Mike McCartney ------------------------------ FormulaI have 2 tables connected. In the parent table, I have a numeric field called Season and a numeric field called Number. In the child table, I have a field called First Season. Currently, I have a field in the child with a drop down showing me the correct Number when Season = First Season. However, I have to pick the only (and correct) choice to populate the field. Can I replace that with a Formula? Or auto populate the field? ------------------------------ Mike McCartney ------------------------------ Re: Print Form in Another TableSame question. Here's my code:URLRoot() & "db/" & Dbid() & "?a=printr&dfid=16&rid=" & [Record ID#] Want to grab from the table called "Player Contracts" ------------------------------ Mike McCartney ------------------------------ Re: Combine FieldsPerfect. Thank you! ------------------------------ Mike McCartney ------------------------------ Re: Combine FieldsGot an error on Line 8 for:If($value>=1000000,"$" & ToFormattedText($value, "comma_dot"), Error>>"IF" cannot be used as part of a variable name ------------------------------ Mike McCartney ------------------------------ Combine FieldsI want to combine 2 fields for a drop down menu choice. One is a 4 digit numeric field (i.e. 2020). The other is a Numeric Currency field (i.e. $100,000,000) How do I combine them? Would like to have it display something like:2020 Year: $100,000,000 ------------------------------ Mike McCartney ------------------------------ Re: Running TotalsThanks Mark. With a lot of trial and error, got it working! ------------------------------ Mike McCartney ------------------------------