Search results

I've two tables, QA (Quality Assurance) and Instruments. I'm using form to add data to QA. There's a field in QA, named InstrumentUsed. The criteria is that InstrmentUsed should only accept value when 'status' field in Instruments table shows 'working'. If status is 'faulty' or 'need repair'...

Thanks CJ. I would go for VBA too, but due to short time I'm looking towards Macro's. Will seek your guidance soon on VBA as well )

can someone guide me towards good online Access 2010 Macro tutorials please?? I'm trying to apply logic to Databases in shortest possible time, and Macro seems to me like a quick solution before I learn VBA. Thanks for anticipation in advance.

Thanks plog, really appreciate your support. I'll work through the proper system in free time. You helped me to know the basic design things, so I'll apply )

Thank you so much for your support. Now I'm one step ahead of where I was before your advices. I've presented my Manager yesterday after the final design, and he said it's too complicated for you at this stage and it'll take a very long time to develop a system if you first want to learn...

Does it mean that we cannot use Foreign Key in a table which doesn't have a direct path from Primary Key to Foreign Key?? I left Job_ID_FK and KKTSCodeFK in index table because they're required in index sheet, and if i don't do that then I'll need complex query to get these values from...

Thank you. Attaching screenshot once again, I hope relationship looks well now?? ) Well it is my 1st project, and it really is complex for a 1st project. Like I mentioned earlier, it is for a Cable Scheduling job for our Engineering Dept. and the guy tried to explain me how the process works...

Thank you. I've redesigned and removed the multiple paths as indicated. Attaching once again, and attaching the Excel sheet too which i'm using to design this database. I've removed the ...CodeDetails Table and created a new column in ...Index table as 'ActivityName'. It is same a detailed...

Thank you, means I've started to understand things )... can you have a final look at last version of relationship table i'm attaching and advice if i've made any mistake in structure please? Also I've made 1 column tables along with ID field, is it ok?? I've done this because otherwise there...

Re: Importing excel data\designing Thanks, attaching after modifications. Does it look better?? What i'm trying to achieve is a bit complex to explain. this is about a Cable Scheduling job tblCableSchedule_CableS... where each cable tblCableSchedule_cabletype... should be pulled between areas...

I'll paste my structure because I'm still talking the Engineering Department. I'm following this thread to understand relationship and my opinions on how to get things right. Then more experienced users like yourself will improve my suggestion. Rest assure, I'm not trying to mix anything up here )

I'm also trying to understand this structure and learn relationships. I'm wondering this DB design involves only few tables and it is difficult to design. My DB is a disaster then, which has many tables relationship and as a beginner I'm in big trouble. I feel there's going to be one junction...

Re: Importing excel data/relationship Thanks for the advice. I'll keep it in mind. This is my first database and is extremely difficult structured. For an Electrical/Instrumentation company and I'm stuck with that. I've posted the first Excel file I received and requested for advices in another...

You mean, I'll add another column as a countryID if i've a column with country name, or shall I change the country names as countryID's??? If yes, why would I do that if I need country names?? Sorry, I tried to understand hard but not getting the point!!

Thanks, I'm doing it now. One more question in relation to this. I've observed that I can copy form Excel and paste in Access, then why we're not using this technique to map our Excel tables in Access? And is there any way to keep the table structure as clean as possible?? I can see 10's o...

Thank you, here are the attachments. I was trying to do this on first post but forum asked me to do 10 posts before i do that. sorry about it. Thanks.

where did the first couple of everything come from?? scientists still could create a single pair... so definitely there's someone!!

Solve my issue too, thanks.

Importing excel data/relationship I'm looking to import huge excel sheets in access, but normalization process in Access has forced me to divide all the columns in Excel to about 12 tables in MS Access. How how could I import data from excel sheet columns to 12 different tables?? Thanks in...

Thanks RainLover