Search options

Hi Derek, thanks a lot, I now understand the approach properly. Once again, your patience and way of explaining is highly appreciated. As an alternative method, is there any possibility to transfer the stdate, enddate and venue information to the report / Edit 1..3 automatically upon loading the form, assuming I'll only have one record at a time in parties / venue?

Hi Derek, I followed the instruction but couldn't figure out how to insert the particular information to the report.
When I open in design view, I see labels [Edit1] , [Edit2 .. 4] appears in the report you've attached.

However, I am not sure how I can insert it in a new report that I design (how to select / where to choose from)?
Lets say I go to a new report design, what I get is the result fields I choose from the table addressbook, (its what I see when I select Button9 of Form1 from your design as well). but where do I get the other values of tables party and venues in report design?

Pls explain.

Hi Derek, Impressed by your ideas, I was just trying to play around within the database and need your help to complete the following since I am missing the basics.

1. I kept the original address book data as it is.
2. Created a separate table for entering party date in to a field named date (DATE)
3. Created a separate table called venues entering venue information (TEXT)

Now, I wanted to print invitations using all three tables and stuck!

Fields I would use for the invitations are;
Name,Address,City,Postcode from table 'addressbook'
Party date from table party, filed 'date' (which will change in the future)
Venue from table venue, field 'venue' (assuming the venue is fixed)

Would appreciate your advise.
Regards.

I am really impressed the way you are playing around within the limitations of MVD to put things right, Great and thank you Derek!

On the other hand hats off to MVD creators for being so practical, I am yet to explore the MVD with Numbers and Calculations (Finance). But so far, things are very impressive. Would appreciate if future versions can come out with better button styles + modern design aspects that can help developers create unique layouts.

Regards.

Hi Derek, apologies for the delay, got your point! Perhaps, can I just do the invitation printing straight from ACTIVE / INACTIVE members instead of adding guests again?

Regards.

Brilliant, Many thanks for the reply Derek, Highly appreciated. That's exactly what my requirement is.

If its not too much, I was planning to have a report that I can print (Name and Address only)  direct based on status to a label sheet  (Avery J8160 Label sheet) which has three columns and seven rows. Is that possible with the same print option available or would that require separate buttons/form? 

Thanks again.