Recent content by Apprentice101

I have three tables with one to many relationships: Customer table Products ordered table Customer ---> prod1 prod2 prod3 customer table locations table Customer ---> location1 location2 location3 I...

thanks LArs7, I will do that

I have three tables with one to many relationships: Customer table Products ordered table Customer ---> prod1 prod2 prod3 customer table locations table Customer ---> location1 location2 location3 I...

thanks Phv, it's a little too much for my level of knowledge, isnt there an easier way? like to build a query with an expression? thanks for your help.

I have the following table. Client Store Products 1 houston shirt 2 austin jeans 3 dallas pijamas 2 austin socks 2 austin Sandals 3 dallas shoes I need to write a query in Access that will...

well, that would mean to have a sequence for each master record wouldnt ?

I have a child (detail) block in tubular form. I need to have a field that will number the regults after the master is queried. ie. MASTER = company details= employees details block looks like this: NUMBER | NAME | LAST_NAME |ADDRESS 1 2 3 4 so I need that for every record on the...

I have a master table (contracts table) with about 20 variables. (about 20 records/ contracts in it) the records are static, they only chage once every 5 years. The idea is that a user queries a customer, if the customer does not have a contract assigned to him/her, the user will open a LOV...

I have actualy done it by creating an insert query from access. Access will do the code for you, its very simple, see the help file "insert queries" the only thing you will need to have is an ODBC connection setup to your orable tables with your host string name and have the tables linked in...

got it, I just found out that rapid sql can let you copy and paste the results as displayed. thanks so much for your input.

GREAT! I WAS ABLE TO RUN THE FOLLOWING QUERY: select * from ALL_TAB_COLUMNS where owner='APPRENTICE' NOW THE ISSUE IS: WHO CAN I DISPLAY THE COMMENTS OF EACH VARIABLE? THAT COLUMN DIDNT SHOW IN THAT QUERY. THANKS!

ok, what else can I retreive with the describe command? and is there anyway to export those results out to a spreedsheet?

What do you mean Sem? I dont know exactly what I can and cannot see. i know I can run describe to any of my tables, ( the ones I own in my instance) that is why I asked you what other queries I can run to see what else is there. I was planning on using the info that the describe command gives...

thanks SEM, well that is exactly why I need to create my own cause I dont have access to the DBA views. SantaMufasa, 1) What does the "Name" column contain? (Table Name, Column Name, other?) "NAME" MEANS THE COLUMN NAME 2) What does the "Description" column contain? "DESCRIPTION MEANS THE...

I am doing data dictionaries for our small dept database. About 40 tables and 1000 variables. I will be doing this on Excel. The columns that I will be using are: Name | Description | Var type | Null?| Label | Constrains as you can see some of those are the output of the Describe command so to...