Search results

  1. A

    border on report

    is it possible to have a border around the whole report? thanks
  2. A

    Late payment fees

    I have one quick question, Is the late payment fee part of the Payments table or does it belong to a different table? I have already posted here http://www.access-programmers.co.uk/forums/showthread.php?t=122393. Thanks
  3. A

    How to apply late fee?

    I have searched and found nothing that can help me out this. OK, I already have the following table setup: tblPayments PmtID PmtDate pmtAmount LatePmtFee loanID etc... I lend someone an x amount of money to pay me an x amount of money every week over a period of time. The interest will be...
  4. A

    How many tables would be needed...

    How many tables would I need for the following: Order# customer date/time order received date/time order due courier (the order might be shipped via two or more different couriers) dept (the order might be sent to three different depts.) the order will be for making photocopies of different...
  5. A

    Referential Integrity

    I am creating a money loan database and I would like someone to give me some advise here. I have created three tables for this money loan database as follow: tblBorrowers BorrowerID LastName FirstName PhoneNumber tblLoans LoanID LoanDate LoanAmount BorrowerID tblPayments PaymentID Interest...
  6. A

    Append ONE Record

    I have search this forum but I have not found a solution to this problem. Ok, I have a form with a combobox and a listbox (multiselect). I want to append the combobox's value in a table based on the records I select in the listbox. So, If I select 3 records in the listbox and then I select a...
  7. A

    Help creating a Form

    tblEmployee EmployeeID pk LastName FirstName tblRoom RoomID pk RoomNumber EmployeeID fk tblExtension ExtensionID pk ExtensionNumber RoomID fk More than one employee works in one room. A room can have more than one extension because different employees work in that room. A room can have one...
  8. A

    Help with tables Relationships

    CompanyID pk (just one company) CompName EmployeeID pk companyID fk roomID fk extensionID fk LName FName LocationID pk RoomNumber (many employees might share same room) PhoneDirectoryID pk ExtNumber (employees might share same extension number) roomID fk ItemID pk ItmName (messengers take...
Back
Top Bottom