Lykus
Last Activity: Mar 23 '09, 04:19 AM
Joined: Nov 17 '06
Location:
-
Table relationship: Bill & Fees tables
What kind of relationship do I need between a table created for "bills" and one for "fees", where there can be more than one fee per bill. In the "fee" table there is a "Fee Name" and a "Fee Charge"? On the "bill" form I use a combo box and I would like to be able to add to the "fee" table using this combo box. -
The information inputted here is done manually from paper invoices received daily. The Amt Billed and Amt Paid are based on a pre-paid/estimated amount paid and a final adjusted amount.
Here are the table/primary key combinations I am using:
tblBill/ProNumber
tblCarrier/CarrierCode
tblClient/ClientCode
tblShipper/ShipperID
tblConsigne/ConsigneeID
The tblBill table has a many-to-one... -
Thanks Dalerna, Jim, missingling, and mshmyob, I really appreciate the time you have taken to help me sort through all of this! I am not sure if I follow every point but I definitely get the main message: by creating a separate Rate History table I will be creating joins that will tax the reporting speed of the database. It would seem that entering in the rate with each billing record makes the best sense from a performance perspective.
...Leave a comment:
-
Best way to maintain billing rate history?
I have created a table for customer bills, and a table for customer profiles which contains rates associated with them specifically. The problem is that after a new rate change has been imposed I want to be able to look at an old bill, via a report, and have it reflect the "old" rate within proper historical context. I'm looking for suggestions on how to best manage ongoing rate changes while maintaining a billing rate history in my r... -
Thank you, missinglinq! This works great, however, I need to be able to circumvent the message box prompt if it is a new record. Someone just informed me that I could use the NewRecord property to do this. The code I was given looks something like this (the control in my example below is dtmDateAssnd):
...Code:Private Sub dtmDateAssnd_BeforeUpdate(Cancel As Integer) Dim strMsg As String Dim iResponse As IntegerLeave a comment:
-
Validating changes to a form field
I would like to be able to enter a value into a field that currently is in a null state without initiating an event but once a value has been assigned to that field that further changes will initiate an event that opens a message box that prompt the user to decide if they want to save the changes or not. Can someone help me with this? -
Okay, I will look into that. Thank you very much!...Leave a comment:
-
Thank you very much pbmods! By the way, how do you handle liability, I am told that one thing to do is to incorporate one's business to prevent personal assets from being claimed in a lawsuit. What are your thoughts on this and do you have any other suggestions?...Leave a comment:
-
Guidelines Needed Charging Clients
Since I left school I have jumped into Microsoft Access database design on my own because I am finding it difficult to find work without 1 to 3 years of experience typically required by the current job market. This leaves me without any gut feeling for how to charge my customers. Charging by the hour is difficult to do fairly because I am not as efficient as more experienced programmers. Charging by the form, query, report, macro, or module, however,... -
Yes, that was the problem! I am surprised I over looked that. I'm sorry to trouble you for something so trivial. Thank you very much for your help.Leave a comment:
-
Problem w/Auto-Numbered Primary Key
I am filling the sender & recipient fields for a logistics company's Invoice table by drawing from a single address table. I enter "new" addresses using two forms (one for the sender field, one for the recipient field) that populate the common address table and the Invoice table's record. As I attempt to create a new address the address table's primary key generates an auto-number, but when I go to close the form after the entry I get... -
Template needed for database w/single input form
My client wants to have a single input form to input data into several different tables. All of this feeds reports that combine the data entered from the single form in different ways.
I need to be able to see all the data on this form, search any field using the Find/Replace button, use a drop down box to be able to choose values that may have already been entered into a given table, and enter in new values not currently in a given...
No activity results to display
Leave a comment: