Search results

Ok i found the method to relate FK to PK: ALTER TABLE tblInvoices ADD CONSTRAINT FK_Test FOREIGN KEY ([PK]) REFERENCES tblCustomers ([PK]) It create one to many relationship: I have question: 1) How to make this 1:1 relationship from SQL level? 2) and how to make this kind relationship...

thank you Minty very much, ok i understand. So there is no other kind of tools or methods to do this? I have to make rels manually in Access ? Jacek

ok thanks but what kind of query? I used odbc connection to link tables with postgres (what is annoying i am getting public_tableName as table name). created foreign key in postgres and tested it in access: and this is perfect. So i know tjat i have RI (relationships integrity in BE) but in...

thank you Minty, I suspect if you pull related tables into a query Access what do you mean ? Just rewrite postgres sql into access sql ? Jacek

The error message tells you where the problem is. tblCustomers ([Last Name]) is not unique but part of a composite PK. So you cannot create a relationship. Make lastname a unique field and it should then work - but then you can only have one customer with a last name of 'Smith'. thanks i...

Hi, i want to somehow see relationships in Access from Postgres. Access can be linked with Postgres and i have for example DDL in Postgres like here: CREATE DATABASE database; CREATE TYPE t_name AS ( first VARCHAR(30), last VARCHAR(60) ); CREATE TABLE telephone_m (...

thank you very much Pat. ALTER TABLE tblInvoices ADD CONSTRAINT FK_LastName FOREIGN KEY ([Last Name]) REFERENCES tblCustomers ([Last Name]) What i am doing wrongly ? Database example in attachment Jacek

Thank you Pat! Totally agree :) thank you, it is nice way! Now i see, i can read CSV, use VBA to create Query on the fly and use DDL statement within it! What i tried is: 1) I created table tblCustomers using this statement: CREATE TABLE tblCustomers (CustomerID INTEGER NOT NULL...

Thank you. What information do you want from me? In my previous post I wrote the purpose - requirements which I have. purpose is to complete task. My boss wants to see tables and rels which he created in his head. That is the all sense or nonsense. I have to implement. What else do you want ...

Thank you Guys. I will get Ddl schema (just structure) from my boss in whatever I want format in csv file or files and he wants to import it to access automatically draw relationships and see them on the diagram. That is all there is no hidden purpose. And I can have composite primary keys (no...

Thank you very much The_Doc_Man!

Thank you. I tried this link: https://docs.microsoft.com/en-us/office/vba/access/concepts/structured-query-language/create-and-delete-tables-and-indexes-using-access-sql And worked! So with SQL i can create tables and set up primary keys. Question is how to relate them after creating? It...

thank you very much ! I am understanding this very nice right now! Jacek

Thank you Pat sorry for my english sometimes it causes issue... Let try to explain: 1. I got question: Can Access consume DDL from flat file? I know from youe help that yes. Can i get example? "No - you tell me how flat file should look like". So in my case for me no matter how DDL will look...

Thank you Guys. Pat, awesome explanation. This statement i want to discuss in details: So in my example it would be like: this is corret approach? Can you please provide example ? Jacek

Thank you Pat, thank you Chris, You mean in Access you can also write something like in SQL Server? what do you need in this input file? Generally i can design the flat file so for me is no matter if i will have data fields in separate table or not. or what is the format --> i can have...

Interesting approach. Thank you. Let's see if more people think like that and if the specific set up is faster or have impact on performance.

No problem. i do not have format for table DDL format - i can use whatever is working for us. You can use only csv file attached - there is table schema. Requirement is: create tables and relationships from CSV file. Whataver format you have there. Best, Jacek

Thank you very much. So you recommending creating PK as autonumber and indexes? But how i can relate this indexes each other? And why this is better than javing multiple primary key? Jacek

Hello, Thanks. Example in Excel attached for tables. Relationships in CSV attached Jacek