Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Josua
  • Order by date
  1. Josua

    Many-to-Many.... with Many problems

    The most complicated part of this (at least to me) is that a voucher may pay for multiple invoices, but it may also only pay for parts of multiple invoices. For example: Voucher A covers 25% of Invoice 1 and 50% of Invoice 2 Voucher B covers 75% of Invoice 1 and 50%...
  2. Josua

    Many-to-Many.... with Many problems

    I see what you are saying, but I have a slightly different setup than these two samples. Where as in the samples, the company is attaching invoices to a customer. But in my situation, it is more easily related to a company getting invoiced by others for doing a service for the company. Then...
  3. Josua

    Many-to-Many.... with Many problems

    I have been working on something that I feel should be very simple. It is a database for invoice and vouchers that pay for the invoices. On the basic level, it is a many to many relationship since one voucher can pay many invoices, and one invoice could be divided among many vouchers. So, I have...
  4. Josua

    Many to Many

    Well I got rid of that error, (had to put it in the query behind the subform) but then it says that it can't be updated still.
  5. Josua

    Many to Many

    I tried to make that work, but this is the error I get: The object doesn't contain the Automation object 'order_id' I have no idea what that means. I even tried making Order_id one of the items that linked to the subform, but that didn't work either.
  6. Josua

    Many to Many

    I have a setup almost exactly like this page demonstrates: http://www.databaseanswers.org/tutorial4_db_schema/tutorial_slide_5.htm Just to keep using this example, say I create a form that is based off the Customer_Order table, and then inside I have a subform, based of the product table. I...
  7. Josua

    Many to Many

    Just for clarity, I'm not worried about changing the PK, I just want to add more. But no new record is made in the related table.
  8. Josua

    Many to Many

    Off of my test db, which I use to try to figure things out, and keep it very simple, I have 3 tables. Task Orders, Vouchers, and intermediate table TaskOrder_Voucher (created due to the fact that it is a many-to-many relationship between Task Orders and Vouchers) Task Orders has a composite...
  9. Josua

    Many to Many

    I have a question that is very similar to this situation, just a different question about it. I have exactly what this person has, with the form and subform in order to do a many to many relationship, and I can edit and create new entries in each of the one-side tables, but the intermediary...
  10. Josua

    Why do forms become uneditable?

    That link provided a very simple answer to my questions. Thank you very much to those who contributed.
  11. Josua

    Why do forms become uneditable?

    Working with Access, I have created a few forms that allow for data entry. I noticed that in some of the cases that some of the forms do not allow the addition of new records, or the editing of any of the information. This seems to be completely seperate from the properties of Allow Edits, Allow...

Part and Inventory Search

Back
Top