Unanswered: How to link fields from one form to another
I actually joined cause am new at Brilliant Database
I have a question you may find silly
I made a form that can calculate the cost and has other fields such as price and quantity (these fields are entered manually) I also have a button that says issue invoice. When I press this button it takes me to another form( I was able to do that) but what I want to know is how can I make the price cost and quantity appear on this form directly according to the company name ( this field is also present in the first form ) and it should be present in the second
HELP PLZ h
When you press the button, have it populate two variables with the Price and Quantity. Then add your line of code that brings you to your new form and then populate the form fields with the contents of the two variables.
can you be more specific please?
in the first form I have list of company names I can choose one
then I fill the fields and after that the cost is calculate
when this is done I press the "issue invoice" button
this button takes me to another form which has
the cost and quantity should be according to the company name since each company has different cost and quantity
thank you for the help
am really sorry for that but am new
how can the company name be linked to the cost and quantity
I mean the 3 should appear in the invoice form
and according to the company name selected in first form the cost and quantity should appear
Just wondering what is the purpose of the "new" form. If for printing, you would normally use a report. You can filter out other fields with the visibility rules if needed or switch to another sheet (with selected fields only). There is likely more then one way to achive what you need - including Tubbritt's suggestion.
I would always suggest making a sample of your application and post it here with text box's explaining what is needed on each form.
here are 2 screen shots
1 of the main form and of the button
the second of the report form I made
I want when I press the button to show some fields present in the first form
I tried show report style but it is not working
From the screen shots, it appears you have what is a fairly standard, customer-invoice/order-item type system. If this is the case you normally set up 3 (or more ) forms and relate these together. Data should only added or edited in its appropriate form to avoid errors. Displaying data is more flexiable sometimes being "creative" to achieve some practical result with the limitations of the program.
A bbd file would likely make this clearer.