Search results

  1. S

    Relationship problems

    Oh Sorry, Windows 7. I will have another look.
  2. S

    trying the inpossible?

    Thanks,Good advice, although hard to realise at the time. I have had a break through, and things are working, my tables forms and a mail merge! my first ever! thanks for your help,
  3. S

    Relationship problems

    Office 2010
  4. S

    trying the inpossible?

    I have created some tables for orders, customers, products and so on, and I hope they are linked properly, and I have been getting help in anotheer thread, but I am wondering, am I expecting too much, and perhaps not using the right part of what access offers. I have already put all my customer...
  5. S

    Relationship problems

    I am unable to attach a copy of my relationships as I cannot get the attachment to be valid. Is this something to with being new? I cannot find a way to zip the file. so I will type it out customer table customer id Primary key first name surname address etc Order Table orderid orderdate...
  6. S

    Relationship problems

    Thanks to you both. I am investigating your suggetions! I will let you know how I go on. Cheers
  7. S

    linking customers and orders

    Thanks, I understand! So really, I should not be worrying that I cannot get to see customer details with their order in table view. You suggest a query view where I could see both, I will try. What about in a form view, so you can enter the order, 'seeing' that it is going to the correct...
  8. S

    Relationship problems

    Thanks, I did see the sticky and I have also looked in google on how to zip a file and have not been able to do so. I seem stuck, and solving one problem seems to lead to another. I have spent a long time reading other threads and trying to learn and apply what I have learnt so that I do not...
  9. S

    Relationship problems

    I have spent a long time following help within other threads but cannot get my database to work. I have taken a screen shot but do not know how to post it to get help--- it was too big :mad: so I will describe. CustomerID is PK in customer table to customer Id FK in order Table, one to many...
  10. S

    linking customers and orders

    :confused: Thanks, I had got a primary field as the foreign field in the other table. I have just spent a long time trying to get the two tables to 'relate'. It just does not seem to work. I just want the first and last name from a customer list (table) to appear on an order table so that I...
  11. S

    linking customers and orders

    I have a simple table of customer details and I wish to link this to a table with orders. I have linked their primary keys. I now wish to create a form to input the customer and thier order so that it all appaers on the screen at once. I have a form for inputting customers. I have another for...
  12. S

    Greetings

    Hi I am late creating a database for a festival in a couple of weeks. I used an older version of access and thought I would be able to remember how. I have become completly stuck with something I am sure is simple. I have joined this to help my sanity as solving the problem and creating a...
Back
Top Bottom