Creating new table

[Switchwork]

Creating new table???

Hello I have just finished creating an Invoice report.

Basically I want to know how I would keep track of the invoices that have been paid??

On the JobsDetails Table I have and Invoice Paid field data type yes/no. (checkbox).

I want to know the best way to keep track of invoices that have been paid.

On some sample databases I have seen Invoice tables. I really don't have a clue how to go about this what to use or anything. So if anyone has any idea what would be the best way to keep track of the invoices that have been paid so I can then do statements for the ones that haven't been paid ya get me??

Please fill me in??

THANX

 

[GUIDO22]

I would create an invoices table and key this to the JobDetails table with using the job identifier. For each job, there would be an associated invoice and on that invoice record (along with date invoiced, invoice number etc.) should be a paid flag (yes/no).

When the invoice has been paid : simply create a query using the two tables to return all records where the Invoice paid flag is not set ie. invoices that are unpaid.

 

[Switchwork]

Thank you for that. Is it easy done????

There is another thing I was wondering if it could somehow be done or something like it??

When I run the query to find the jobs that have been paid is there a way of Archiving those jobs (put them into a JobHistoryTble) or something?? Basically I want them out of the Main JobDetailsTble. Ya get what I mean???

Is there a way of doing this??

Thanx again for the Invoice table suggestion. Is this the best and most efficient way of doing that type of thing then???

THANK you and let me know on the ARCHIVING THING yeah??

RESPECT!!!!!

 

[jfgambit]

Archiving them to another table is moving away from a Normalized database. It is going to cause you problems by requiring you to create additonal forms for accessing old information.

A suggestions:

Create a DatePd field in your invoice table. You can then enter the date for each paid invoice or create a command button that time stamps the field with the current date and time. You can search old records utilizing this field, and even have the records not appear on a work order form by filtering out records where DatePd = Null.

HTH

 

[Switchwork]

Command Buttons???

How do I create a command button??

I thought that was getting into the complicated stuff??

Is it easier than I thought??

I would appreciate someone letting me know how to go about creating command buttons.

One more thing can I use command buttons to print reports and preview reports and things???

Is it the same as a switchboard type thing??

Please let me know how I go about doing this Command button buisness I would be most grateful.

Thanx for the advice about the Invoice Arichiving thing i guess that is the best way to go about doing things.

please get back to me look forward to seeing your words soon!!!!
THANX AND RESPECT!!!!!